DBA Data[Home] [Help]

APPS.PER_MX_SSAFFL_DISPMAG dependencies on HR_ORGANIZATION_INFORMATION

Line 279: from hr_organization_information hoi

275: and (( cp_trans_gre_id is not null and cp_gre_id is not null and pai.tax_unit_id= cp_gre_id )
276: or ( cp_trans_gre_id is not null and cp_gre_id is null and
277: pai.tax_unit_id in
278: (select organization_id
279: from hr_organization_information hoi
280: where hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
281: and ((org_information6 = cp_trans_gre_id ) OR ( organization_id = cp_trans_gre_id and org_information3='Y')))))
282: and not exists (
283: select 'Y'

Line 1154: from hr_organization_information

1150: -- Cursor to get the IMSS Waybill Number
1151: cursor c_get_org_information ( cp_organization_id in number)
1152: is
1153: select org_information5
1154: from hr_organization_information
1155: where org_information_context= 'MX_SOC_SEC_DETAILS'
1156: and organization_id = cp_organization_id ;
1157:
1158: