APPS.PAY_CA_EOY_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 1373: hr_organization_information hoi6,

1369: hl.COUNTRY GRE_country,
1370: hoi6.org_information3 ei_rate
1371: from
1372: hr_all_organization_units hou,
1373: hr_organization_information hoi6,
1374: hr_locations_all hl
1375: where
1376: hou.organization_id = p_tax_unit_id
1377: and hou.organization_id = hoi6.organization_id

Line 1392: hr_organization_information hoi5

1388: hoi5.ORG_INFORMATION14 GRE_Proprietor_SIN#1,
1389: hoi5.ORG_INFORMATION15 GRE_Proprietor_SIN#2/*,
1390: hoi5.ORG_INFORMATION16 GRE_Fedyouth_hire_Prgind*/
1391: from
1392: hr_organization_information hoi5
1393: where
1394: hoi5.organization_id = p_tax_unit_id
1395: and hoi5.org_information_context = 'Fed Magnetic Reporting';
1396:

Line 1421: hr_organization_information hoi2,

1417: hoi2.ORG_INFORMATION17 trans_tech_contact_extn,
1418: hoi2.ORG_INFORMATION18 trans_tech_contact_email
1419: from
1420: hr_all_organization_units hou,
1421: hr_organization_information hoi2,
1422: hr_organization_information hoi3,
1423: hr_locations_all hl
1424: where
1425: hou.organization_id = p_transmitter_gre_id

Line 1422: hr_organization_information hoi3,

1418: hoi2.ORG_INFORMATION18 trans_tech_contact_email
1419: from
1420: hr_all_organization_units hou,
1421: hr_organization_information hoi2,
1422: hr_organization_information hoi3,
1423: hr_locations_all hl
1424: where
1425: hou.organization_id = p_transmitter_gre_id
1426: and hou.organization_id = hoi2.organization_id

Line 2326: from hr_organization_information

2322: /* Call the archive_gre_data procedure */
2323: if l_chunk = g_min_chunk and g_archive_flag = 'N' then
2324: select org_information11
2325: into l_transmitter_gre_id
2326: from hr_organization_information
2327: where organization_id = l_tax_unit_id
2328: and org_information_context = 'Canada Employer Identification';
2329:
2330: l_step := 3;

Line 3778: from hr_organization_information

3774: l_eoy_tax_unit_id := get_parameter('TRANSFER_GRE',l_legislative_parameters);
3775:
3776: select org_information11
3777: into l_transmitter_gre_id
3778: from hr_organization_information
3779: where organization_id = l_eoy_tax_unit_id
3780: and org_information_context = 'Canada Employer Identification';
3781:
3782: hr_utility.trace('Transfer GRE is '|| to_char(l_eoy_tax_unit_id));