SELECT tu.TLSUBBRID, tu.SECUR_CODE FROM TL_USER tu WHERE tu.TLNANME = 'phuongtln1'
SELECT pc.DVDM_ID FROM PL_COSTCENTER_DT pcd
LEFT JOIN PL_COSTCENTER pc ON pcd.COST_ID = pc.COST_ID
WHERE pcd.BRANCH_ID = 'DV0001' AND pcd.DEP_ID = 'DEP000000000014'