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 335: numbers from hr_organization_information.

331: It will be used to get Starting and
332: Ending slip numbers.
333: 14-SEP-2011 rgottipa 115.115 11694701 Romoved the new cursor c_get_rl1_pdf_slip.
334: Trying to fetch Starting and Ending slip
335: numbers from hr_organization_information.
336: 19-SEP-2011 rgottipa 115.116 12996280 Handling no_data_found exception
337: while capturing starting and ending
338: slip numbers.
339: 08-Dec-2011 rgottipa 115.117 13360872 Changes done to support new database

Line 1128: from hr_organization_information hoi

1124: AND SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
1125: AND (
1126: (rtrim(ltrim(SCL.segment1)) in
1127: (select to_char(hoi.organization_id)
1128: from hr_organization_information hoi
1129: where hoi.org_information_context = 'Canada Employer Identification'
1130: and hoi.org_information2 = l_pre_organization_id))
1131: or
1132: (rtrim(ltrim(SCL.segment11)) in

Line 1134: from hr_organization_information hoi

1130: and hoi.org_information2 = l_pre_organization_id))
1131: or
1132: (rtrim(ltrim(SCL.segment11)) in
1133: (select to_char(hoi.organization_id)
1134: from hr_organization_information hoi
1135: where hoi.org_information_context = 'Canada Employer Identification'
1136: and hoi.org_information2 = l_pre_organization_id))
1137: )
1138: AND PPY.payroll_id = ASG.payroll_id

Line 1163: from hr_organization_information hoi

1159: AND ppa.action_type in ('R','Q','V','B','I')
1160: AND ppa.business_group_id +0 = l_bus_group_id
1161: AND ppa.payroll_action_id = paa.payroll_action_id
1162: AND paa.tax_unit_id in (select hoi.organization_id
1163: from hr_organization_information hoi
1164: where hoi.org_information_context ||''= 'Canada Employer Identification'
1165: and hoi.org_information2 = l_pre_organization_id
1166: and hoi.org_information5 in ('T4/RL1','T4A/RL1'))
1167: AND paa.assignment_id = asg.assignment_id

Line 1200: from hr_organization_information hoi

1196: AND ppa.action_type in ('R','Q','V','B','I')
1197: AND ppa.business_group_id +0 = l_bus_group_id
1198: AND ppa.payroll_action_id = paa.payroll_action_id
1199: AND paa.tax_unit_id in (select hoi.organization_id
1200: from hr_organization_information hoi
1201: where hoi.org_information_context ||''= 'Canada Employer Identification'
1202: and hoi.org_information2 = l_pre_organization_id
1203: and hoi.org_information5 in ('T4/RL1','T4A/RL1'))
1204: AND paa.assignment_id = asg.assignment_id

Line 1225: from hr_organization_information hoi

1221: ORDER BY 1, 3 DESC, 2;
1222:
1223: cursor c_all_qbin_gres is
1224: select hoi.organization_id
1225: from hr_organization_information hoi
1226: where hoi.org_information_context = 'Canada Employer Identification'
1227: and hoi.org_information2 = l_pre_organization_id;
1228:
1229: /* Get the primary assignment for the given person_id */

Line 1717: from hr_organization_information target1 ,

1713: substr(target1.ORG_INFORMATION18,1,8) RL1_Slip_Number,
1714: decode(target1.org_information3,'Y',target1.organization_id,
1715: target1.ORG_INFORMATION20),
1716: target1.ORG_INFORMATION3
1717: from hr_organization_information target1 ,
1718: hr_all_organization_units target2
1719: where target1.organization_id = to_number(p_pre_organization_id)
1720: and target2.business_group_id = l_business_group_id
1721: and target2.organization_id = target1.organization_id

Line 2337: hr_organization_information hoi,

2333: select decode(hoi.org_information3,'Y',hoi.organization_id,
2334: hoi.org_information20)
2335: into l_transmitter_name1
2336: from pay_payroll_actions ppa,
2337: hr_organization_information hoi,
2338: hr_all_organization_units hou
2339: WHERE hou.business_group_id = ppa.business_group_id
2340: and hoi.organization_id = hou.organization_id
2341: and hoi.org_information_context='Prov Reporting Est'

Line 2356: from hr_organization_information target

2352:
2353: -- Added for bug 11694701
2354: /* select to_number(target.ORG_INFORMATION18)
2355: into l_rl1_last_slip_number
2356: from hr_organization_information target
2357: where target.organization_id = l_transmitter_name1
2358: and target.org_information_context = 'Prov Reporting Est'
2359: and target.ORG_INFORMATION3 = 'Y';*/
2360: Begin

Line 2363: from hr_organization_information target

2359: and target.ORG_INFORMATION3 = 'Y';*/
2360: Begin
2361: select to_number(target.ORG_INFORMATION1),to_number(target.ORG_INFORMATION2)
2362: into l_rl1_starting_slip_num,l_rl1_ending_slip_num
2363: from hr_organization_information target
2364: where target.organization_id = l_transmitter_name1
2365: and target.org_information_context = 'Prov Reporting Est3'
2366: and exists (select 'X' from hr_organization_information target1
2367: where target1.organization_id = l_transmitter_name1

Line 2366: and exists (select 'X' from hr_organization_information target1

2362: into l_rl1_starting_slip_num,l_rl1_ending_slip_num
2363: from hr_organization_information target
2364: where target.organization_id = l_transmitter_name1
2365: and target.org_information_context = 'Prov Reporting Est3'
2366: and exists (select 'X' from hr_organization_information target1
2367: where target1.organization_id = l_transmitter_name1
2368: and target1.org_information_context = 'Prov Reporting Est'
2369: and target1.ORG_INFORMATION3 = 'Y');
2370: exception -- added exception for bug 12996280

Line 2497: hr_organization_information hoi

2493: cursor c_all_gres_for_further_info(asgactid number) is
2494: select hoi.organization_id
2495: from pay_payroll_actions ppa,
2496: pay_assignment_actions paa,
2497: hr_organization_information hoi
2498: where paa.assignment_action_id = asgactid
2499: and ppa.payroll_action_id = paa.payroll_action_id
2500: and hoi.org_information2 =
2501: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

Line 2958: hr_organization_information hoi

2954: select hoi.organization_id ,
2955: hoi.org_information5
2956: from pay_payroll_actions ppa,
2957: pay_assignment_actions paa,
2958: hr_organization_information hoi
2959: where paa.assignment_action_id = asgactid
2960: and ppa.payroll_action_id = paa.payroll_action_id
2961: and hoi.org_information2 =
2962: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

Line 2973: hr_organization_information hoi

2969: select hoi.organization_id ,
2970: hoi.org_information5
2971: from pay_payroll_actions ppa,
2972: pay_assignment_actions paa,
2973: hr_organization_information hoi
2974: where paa.assignment_action_id = asgactid
2975: and ppa.payroll_action_id = paa.payroll_action_id
2976: and hoi.org_information2 =
2977: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

Line 3083: , hr_organization_information hoi

3079: , pay_payroll_actions arch_ppa
3080: , per_all_assignments_f arch_paf
3081: , per_all_assignments_f all_paf
3082: , hr_all_organization_units hou
3083: , hr_organization_information hoi
3084: where arch_paa.assignment_action_id = cp_asgactid
3085: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id
3086: and hou.business_group_id + 0 = arch_ppa.business_group_id
3087: and hou.organization_id = hoi.organization_id

Line 5137: from hr_organization_information hoi

5133: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'
5134: and ppa.payroll_action_id = paa.payroll_action_id
5135: and paa.tax_unit_id in
5136: (select hoi.organization_id
5137: from hr_organization_information hoi
5138: where hoi.org_information_context = ''Canada Employer Identification''
5139: and hoi.org_information2 = '''|| l_pre_organization_id ||''''||'
5140: and hoi.org_information5 in (''T4/RL1'',''T4A/RL1''))
5141: and paa.action_status = ''C''