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_EOY_RL1_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 1032: from hr_organization_information hoi

1028: AND SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
1029: AND (
1030: (rtrim(ltrim(SCL.segment1)) in
1031: (select to_char(hoi.organization_id)
1032: from hr_organization_information hoi
1033: where hoi.org_information_context = 'Canada Employer Identification'
1034: and hoi.org_information2 = l_pre_organization_id))
1035: or
1036: (rtrim(ltrim(SCL.segment11)) in

Line 1038: from hr_organization_information hoi

1034: and hoi.org_information2 = l_pre_organization_id))
1035: or
1036: (rtrim(ltrim(SCL.segment11)) in
1037: (select to_char(hoi.organization_id)
1038: from hr_organization_information hoi
1039: where hoi.org_information_context = 'Canada Employer Identification'
1040: and hoi.org_information2 = l_pre_organization_id))
1041: )
1042: AND PPY.payroll_id = ASG.payroll_id

Line 1067: from hr_organization_information hoi

1063: AND ppa.action_type in ('R','Q','V','B','I')
1064: AND ppa.business_group_id +0 = l_bus_group_id
1065: AND ppa.payroll_action_id = paa.payroll_action_id
1066: AND paa.tax_unit_id in (select hoi.organization_id
1067: from hr_organization_information hoi
1068: where hoi.org_information_context ||''= 'Canada Employer Identification'
1069: and hoi.org_information2 = l_pre_organization_id
1070: and hoi.org_information5 in ('T4/RL1','T4A/RL1'))
1071: AND paa.assignment_id = asg.assignment_id

Line 1089: from hr_organization_information hoi

1085: ORDER BY 1, 3 DESC, 2;
1086:
1087: cursor c_all_qbin_gres is
1088: select hoi.organization_id
1089: from hr_organization_information hoi
1090: where hoi.org_information_context = 'Canada Employer Identification'
1091: and hoi.org_information2 = l_pre_organization_id;
1092:
1093: /* Get the primary assignment for the given person_id */

Line 1520: from hr_organization_information target1 ,

1516: substr(target1.ORG_INFORMATION18,1,8) RL1_Slip_Number,
1517: decode(target1.org_information3,'Y',target1.organization_id,
1518: target1.ORG_INFORMATION20),
1519: target1.ORG_INFORMATION3
1520: from hr_organization_information target1 ,
1521: hr_all_organization_units target2
1522: where target1.organization_id = to_number(p_pre_organization_id)
1523: and target2.business_group_id = l_business_group_id
1524: and target2.organization_id = target1.organization_id

Line 2136: hr_organization_information hoi

2132: select hoi.organization_id ,
2133: hoi.org_information5
2134: from pay_payroll_actions ppa,
2135: pay_assignment_actions paa,
2136: hr_organization_information hoi
2137: where paa.assignment_action_id = asgactid
2138: and ppa.payroll_action_id = paa.payroll_action_id
2139: and hoi.org_information2 =
2140: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

Line 2151: hr_organization_information hoi

2147: select hoi.organization_id ,
2148: hoi.org_information5
2149: from pay_payroll_actions ppa,
2150: pay_assignment_actions paa,
2151: hr_organization_information hoi
2152: where paa.assignment_action_id = asgactid
2153: and ppa.payroll_action_id = paa.payroll_action_id
2154: and hoi.org_information2 =
2155: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

Line 2260: , hr_organization_information hoi

2256: , pay_payroll_actions arch_ppa
2257: , per_all_assignments_f arch_paf
2258: , per_all_assignments_f all_paf
2259: , hr_all_organization_units hou
2260: , hr_organization_information hoi
2261: where arch_paa.assignment_action_id = cp_asgactid
2262: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id
2263: and hou.business_group_id + 0 = arch_ppa.business_group_id
2264: and hou.organization_id = hoi.organization_id

Line 2527: hr_organization_information hoi,

2523: select decode(hoi.org_information3,'Y',hoi.organization_id,
2524: hoi.org_information20)
2525: into l_transmitter_name1
2526: from pay_payroll_actions ppa,
2527: hr_organization_information hoi,
2528: hr_all_organization_units hou
2529: WHERE hou.business_group_id = ppa.business_group_id
2530: and hoi.organization_id = hou.organization_id
2531: and hoi.org_information_context='Prov Reporting Est'

Line 2546: from hr_organization_information target

2542: if l_transmitter_name1 is not null then
2543:
2544: select to_number(target.ORG_INFORMATION18)
2545: into l_rl1_last_slip_number
2546: from hr_organization_information target
2547: where target.organization_id = l_transmitter_name1
2548: and target.org_information_context = 'Prov Reporting Est'
2549: and target.ORG_INFORMATION3 = 'Y';
2550:

Line 4112: from hr_organization_information hoi

4108: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'
4109: and ppa.payroll_action_id = paa.payroll_action_id
4110: and paa.tax_unit_id in
4111: (select hoi.organization_id
4112: from hr_organization_information hoi
4113: where hoi.org_information_context = ''Canada Employer Identification''
4114: and hoi.org_information2 = '''|| l_pre_organization_id ||''''||'
4115: and hoi.org_information5 in (''T4/RL1'',''T4A/RL1''))
4116: and paa.action_status = ''C''