[Home] [Help]
476: checking against the new values returned from within the loop on the
477: next iteration. */
478:
479: l_prev_person_id per_all_people_f.person_id%type;
480: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
481:
482: /* Variable to hold the jurisdiction code used as a context for state
483: reporting. */
484:
1233: hoi2.ORG_INFORMATION10 trans_acct_contact_name,
1234: hoi2.ORG_INFORMATION11 trans_acct_contact_area_code,
1235: hoi2.ORG_INFORMATION12 trans_acct_contact_phone,
1236: hoi2.ORG_INFORMATION13 trans_acct_contact_extn
1237: from hr_all_organization_units ou1, /* transmitter org */
1238: hr_organization_information hoi1, /* Transmitter GRE to check
1239: GRE/Legal Classification is enabled */
1240: hr_organization_information hoi2, /* Transmitter GRE to check
1241: 'Fed Magnetic Reporting' */
1241: 'Fed Magnetic Reporting' */
1242: hr_organization_information hoi3, /* Transmitter GRE to check
1243: 'Employer Identification' */
1244: hr_locations_all hl1, /* trans location */
1245: hr_all_organization_units ou2, /* GRE Org */
1246: hr_organization_information hoi4, /* GRE to check GRE/Legal
1247: Classification is enabled */
1248: hr_organization_information hoi6, /* GRE to check
1249: 'Employer Identification'*/
1899: , pay_assignment_actions arch_paa
1900: , pay_payroll_actions arch_ppa
1901: , per_all_assignments_f arch_paf
1902: , per_all_assignments_f all_paf
1903: , hr_all_organization_units hou
1904: , hr_organization_information hoi
1905: where arch_paa.assignment_action_id = cp_asgact_id
1906: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id
1907: and hou.business_group_id = arch_ppa.business_group_id
2072:
2073: /* YE-2001 change to avoid hr_ca_tax_units_v view */
2074: select business_group_id
2075: into l_business_group_id
2076: from hr_all_organization_units
2077: where organization_id = l_tax_unit_id;
2078:
2079: l_step := 1;
2080: