APPS.PAY_MX_SSAFFL_SALARY dependencies on HR_ORGANIZATION_INFORMATION

Line 143: from hr_organization_information

139:
140: cursor c_get_imp_date(cp_organization_id in number)
141: is
142: select fnd_date.canonical_to_date(org_information6)
143: from hr_organization_information
144: where org_information_context= 'MX_TAX_REGISTRATION'
145: and organization_id = cp_organization_id ;
146:
147: ld_report_imp_date date ;

Line 299: from hr_organization_information

295:
296: cursor c_get_imp_date(cp_organization_id in number)
297: is
298: select fnd_date.canonical_to_date(org_information6)
299: from hr_organization_information
300: where org_information_context= 'MX_TAX_REGISTRATION'
301: and organization_id = cp_organization_id ;
302:
303:

Line 541: from hr_organization_information hoi

537: or ( ''' ||ln_tran_gre_id || ''' is not null and ''' ||ln_gre_id || ''' is null and
538: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)
539: in
540: (select organization_id
541: from hr_organization_information hoi
542: where hoi.org_information_context = ''MX_SOC_SEC_DETAILS''
543: and ((org_information6 = ''' ||ln_tran_gre_id || ''' ) OR
544: ( organization_id = ''' ||ln_tran_gre_id || ''' and org_information3=''Y'')))))
545: and :payroll_action_id > 0 ' ;

Line 605: from hr_organization_information hoi

601: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf1.location_id,paf1.business_group_id,paf1.soft_coding_keyflex_id,
602: fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_period_end_date) || '''))
603: in
604: (select organization_id
605: from hr_organization_information hoi
606: where hoi.org_information_context = ''MX_SOC_SEC_DETAILS''
607: and ((org_information6 = ''' ||ln_tran_gre_id || ''' ) OR
608: ( organization_id = ''' ||ln_tran_gre_id || ''' and org_information3=''Y'')))))
609: and :payroll_action_id > 0 ' ;

Line 679: from hr_organization_information hoi

675: or ( cp_tran_gre_id is not null and cp_gre_id is null and
676: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)
677: in
678: (select organization_id
679: from hr_organization_information hoi
680: where hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
681: and ((org_information6 = cp_tran_gre_id ) OR ( organization_id = cp_tran_gre_id and org_information3='Y')))))
682: ;
683:

Line 747: from hr_organization_information hoi

743: or ( cp_tran_gre_id is not null and cp_gre_id is null and
744: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf1.location_id,paf1.business_group_id,paf1.soft_coding_keyflex_id,cp_period_end_date)
745: in
746: (select organization_id
747: from hr_organization_information hoi
748: where hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
749: and ((org_information6 = cp_tran_gre_id )
750: OR ( organization_id = cp_tran_gre_id and org_information3='Y'))))) ;
751:

Line 1020: from hr_organization_information

1016:
1017: cursor c_get_er_ss_number(cp_gre_id in number )
1018: is
1019: select replace(org_information1,'-','')
1020: from hr_organization_information
1021: where org_information_context= 'MX_SOC_SEC_DETAILS'
1022: and organization_id = cp_gre_id ;
1023:
1024: cursor c_get_org_information ( cp_organization_id in number)

Line 1027: from hr_organization_information

1023:
1024: cursor c_get_org_information ( cp_organization_id in number)
1025: is
1026: select org_information3,org_information5, org_information6
1027: from hr_organization_information
1028: where org_information_context= 'MX_SOC_SEC_DETAILS'
1029: and organization_id = cp_organization_id ;
1030:
1031: -- cursor to get the minimum wage for Zone A