eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 1238: hr_organization_information hoi1, /* Transmitter GRE to check

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' */
1242: hr_organization_information hoi3, /* Transmitter GRE to check

Line 1240: hr_organization_information hoi2, /* Transmitter GRE to check

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' */
1242: hr_organization_information hoi3, /* Transmitter GRE to check
1243: 'Employer Identification' */
1244: hr_locations_all hl1, /* trans location */

Line 1242: hr_organization_information hoi3, /* Transmitter GRE to check

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' */
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

Line 1246: hr_organization_information hoi4, /* GRE to check GRE/Legal

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'*/
1250: hr_locations_all hl2, /* GRE location */

Line 1248: hr_organization_information hoi6, /* GRE to check

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'*/
1250: hr_locations_all hl2, /* GRE location */
1251: per_business_groups bg
1252: where bg.business_group_id = ou1.business_group_id

Line 1286: from hr_organization_information hoi

1282: hoi.ORG_INFORMATION13 GRE_acct_contact_extn,
1283: hoi.ORG_INFORMATION14 GRE_Proprietor_SIN#1,
1284: hoi.ORG_INFORMATION15 GRE_Proprietor_SIN#2,
1285: hoi.ORG_INFORMATION16 GRE_Fedyouth_hire_Prgind
1286: from hr_organization_information hoi
1287: where hoi.organization_id = cp_gre_id
1288: and hoi.org_information_context = 'Fed Magnetic Reporting';
1289:
1290: begin

Line 1904: , hr_organization_information hoi

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
1908: and hou.organization_id = hoi.organization_id

Line 2045: from hr_organization_information

2041: /* Call the archive_gre_data procedure */
2042: if l_chunk = g_min_chunk and g_archive_flag = 'N' then
2043: select org_information11
2044: into l_transmitter_gre_id
2045: from hr_organization_information
2046: where organization_id = l_tax_unit_id
2047: and org_information_context = 'Canada Employer Identification';
2048:
2049: l_step := 3;

Line 3775: from hr_organization_information

3771: l_eoy_tax_unit_id := pycadar_pkg.get_parameter('TRANSFER_GRE',l_legislative_parameters);
3772:
3773: select org_information11
3774: into l_transmitter_gre_id
3775: from hr_organization_information
3776: where organization_id = l_eoy_tax_unit_id
3777: and org_information_context = 'Canada Employer Identification'
3778: and org_information5 in ('T4A/RL1','T4A/RL2');
3779: