APPS.PAY_CA_EOY_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 1550: hr_organization_information hoi6,

1546: hl.COUNTRY GRE_country,
1547: hoi6.org_information3 ei_rate
1548: from
1549: hr_all_organization_units hou,
1550: hr_organization_information hoi6,
1551: hr_locations_all hl
1552: where
1553: hou.organization_id = p_tax_unit_id
1554: and hou.organization_id = hoi6.organization_id

Line 1569: hr_organization_information hoi5

1565: hoi5.ORG_INFORMATION14 GRE_Proprietor_SIN#1,
1566: hoi5.ORG_INFORMATION15 GRE_Proprietor_SIN#2/*,
1567: hoi5.ORG_INFORMATION16 GRE_Fedyouth_hire_Prgind*/
1568: from
1569: hr_organization_information hoi5
1570: where
1571: hoi5.organization_id = p_tax_unit_id
1572: and hoi5.org_information_context = 'Fed Magnetic Reporting';
1573:

Line 1606: hr_organization_information hoi2,

1602: hoi2.ORG_INFORMATION17 trans_tech_contact_extn,
1603: hoi2.ORG_INFORMATION18 trans_tech_contact_email
1604: from
1605: hr_all_organization_units hou,
1606: hr_organization_information hoi2,
1607: hr_organization_information hoi3,
1608: hr_locations_all hl
1609: where
1610: hou.organization_id = p_transmitter_gre_id

Line 1607: hr_organization_information hoi3,

1603: hoi2.ORG_INFORMATION18 trans_tech_contact_email
1604: from
1605: hr_all_organization_units hou,
1606: hr_organization_information hoi2,
1607: hr_organization_information hoi3,
1608: hr_locations_all hl
1609: where
1610: hou.organization_id = p_transmitter_gre_id
1611: and hou.organization_id = hoi2.organization_id

Line 2632: from hr_organization_information

2628: /* Call the archive_gre_data procedure */
2629: if l_chunk = g_min_chunk and g_archive_flag = 'N' then
2630: select org_information11
2631: into l_transmitter_gre_id
2632: from hr_organization_information
2633: where organization_id = l_tax_unit_id
2634: and org_information_context = 'Canada Employer Identification';
2635:
2636: l_step := 3;

Line 4405: from hr_organization_information

4401: l_eoy_tax_unit_id := get_parameter('TRANSFER_GRE',l_legislative_parameters);
4402:
4403: select org_information11
4404: into l_transmitter_gre_id
4405: from hr_organization_information
4406: where organization_id = l_eoy_tax_unit_id
4407: and org_information_context = 'Canada Employer Identification';
4408:
4409: hr_utility.trace('Transfer GRE is '|| to_char(l_eoy_tax_unit_id));