APPS.PER_MX_SSAFFL_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 230: from hr_organization_information

226:
227: cursor c_get_imp_date(cp_organization_id in number)
228: is
229: select fnd_date.canonical_to_date(org_information6)
230: from hr_organization_information
231: where org_information_context= 'MX_TAX_REGISTRATION'
232: and organization_id = cp_organization_id ;
233:
234: ld_report_imp_date date ;

Line 345: from hr_organization_information

341:
342: cursor c_get_imp_date(cp_organization_id in number)
343: is
344: select fnd_date.canonical_to_date(org_information6)
345: from hr_organization_information
346: where org_information_context= 'MX_TAX_REGISTRATION'
347: and organization_id = cp_organization_id ;
348:
349:

Line 657: from hr_organization_information hoi

653: or ( cp_tran_gre_id is not null and cp_gre_id is null and
654: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)
655: in
656: (select organization_id
657: from hr_organization_information hoi
658: where hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
659: and ((org_information6 = cp_tran_gre_id ) OR ( organization_id = cp_tran_gre_id and org_information3='Y'))))) ;
660:
661:

Line 925: from hr_organization_information

921:
922: cursor c_get_er_ss_number(cp_gre_id in number )
923: is
924: select org_information1
925: from hr_organization_information
926: where org_information_context= 'MX_SOC_SEC_DETAILS'
927: and organization_id = cp_gre_id ;
928:
929: cursor c_get_org_information ( cp_organization_id in number)

Line 932: from hr_organization_information

928:
929: cursor c_get_org_information ( cp_organization_id in number)
930: is
931: select org_information3,org_information5, org_information6
932: from hr_organization_information
933: where org_information_context= 'MX_SOC_SEC_DETAILS'
934: and organization_id = cp_organization_id ;
935:
936: cursor c_get_leaving_reason( cp_assignment_id in number

Line 1181: from hr_organization_information

1177:
1178: cursor c_get_er_ss_number(cp_gre_id in number )
1179: is
1180: select replace(org_information1,'-','')
1181: from hr_organization_information
1182: where org_information_context= 'MX_SOC_SEC_DETAILS'
1183: and organization_id = cp_gre_id ;
1184:
1185: cursor c_get_org_information ( cp_organization_id in number)

Line 1188: from hr_organization_information

1184:
1185: cursor c_get_org_information ( cp_organization_id in number)
1186: is
1187: select org_information3,org_information5, org_information6
1188: from hr_organization_information
1189: where org_information_context= 'MX_SOC_SEC_DETAILS'
1190: and organization_id = cp_organization_id ;
1191:
1192: