[Home] [Help]
915: AND ASG.effective_end_date >= l_period_start
916: AND SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
917: AND rtrim(ltrim(SCL.segment12)) in
918: (select to_char(hoi.organization_id)
919: from hr_organization_information hoi
920: where hoi.org_information_context = 'Canada Employer Identification'
921: and hoi.org_information2 = l_pre_org_id
922: and hoi.org_information5 = 'T4A/RL2')
923: AND PPY.payroll_id = ASG.payroll_id
947: AND ppa.action_type in ('R','Q','V','B','I')
948: AND ppa.business_group_id +0 = l_bus_group_id
949: AND ppa.payroll_action_id = paa.payroll_action_id
950: AND paa.tax_unit_id in (select hoi.organization_id
951: from hr_organization_information hoi
952: where hoi.org_information_context ||''= 'Canada Employer Identification'
953: and hoi.org_information2 = l_pre_org_id
954: and hoi.org_information5 = 'T4A/RL2')
955: AND paa.assignment_id = asg.assignment_id
969: ORDER BY 1, 3 DESC, 2;
970:
971: cursor c_all_qbin_gres is
972: select hoi.organization_id
973: from hr_organization_information hoi
974: where hoi.org_information_context = 'Canada Employer Identification'
975: and hoi.org_information2 = l_pre_org_id
976: and hoi.org_information5 = 'T4A/RL2';
977:
1340: substr(target1.ORG_INFORMATION18,1,8) RL2_Slip_Number,
1341: decode(target1.org_information3,'Y',target1.organization_id,
1342: to_number(target1.ORG_INFORMATION20)),
1343: target1.ORG_INFORMATION3
1344: from hr_organization_information target1,
1345: hr_all_organization_units target2
1346: where target1.organization_id = to_number(p_pre_org_id)
1347: and target2.business_group_id = l_business_group_id
1348: and target2.organization_id = target1.organization_id
1915: select hoi.organization_id ,
1916: hoi.org_information5
1917: from pay_action_information pac,
1918: pay_assignment_actions paa,
1919: hr_organization_information hoi
1920: where paa.assignment_action_id = asgactid
1921: and pac.action_context_id = paa.payroll_action_id
1922: and pac.action_information_category = 'CAEOY TRANSMITTER INFO'
1923: and pac.action_information1 = 'RL2'
1931: select hoi.organization_id ,
1932: hoi.org_information5
1933: from pay_action_information pac,
1934: pay_assignment_actions paa,
1935: hr_organization_information hoi
1936: where paa.assignment_action_id = asgactid
1937: and pac.action_context_id = paa.payroll_action_id
1938: and pac.action_information_category = 'CAEOY TRANSMITTER INFO'
1939: and pac.action_information1 = 'RL2'
2194: begin
2195: select decode(hoi.org_information3,'Y',hoi.organization_id,
2196: hoi.org_information20)
2197: into l_transmitter_id
2198: from hr_organization_information hoi,
2199: hr_all_organization_units hou
2200: WHERE hou.business_group_id = l_business_group_id
2201: and hoi.organization_id = hou.organization_id
2202: and hoi.org_information_context = 'Prov Reporting Est'
2209: hr_utility.trace('3');
2210:
2211: select to_number(target.ORG_INFORMATION18)
2212: into l_rl2_last_slip_number
2213: from hr_organization_information target
2214: where target.organization_id = l_transmitter_id
2215: and target.org_information_context = 'Prov Reporting Est'
2216: and target.ORG_INFORMATION3 = 'Y';
2217:
2235:
2236: begin
2237: select hoi.org_information1,hoi.org_information2
2238: into l_pre_source_of_income,l_pre_description
2239: from hr_organization_information hoi
2240: where hoi.organization_id = l_transmitter_id
2241: and hoi.org_information_context = 'Prov Reporting Est2';
2242:
2243: exception
3250: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'
3251: and ppa.payroll_action_id = paa.payroll_action_id
3252: and paa.tax_unit_id in
3253: (select hoi.organization_id
3254: from hr_organization_information hoi
3255: where hoi.org_information_context = ''Canada Employer Identification''
3256: and hoi.org_information2 = '''|| l_pre_org_id ||''''||'
3257: and hoi.org_information5 = ''T4A/RL2'')
3258: and paa.action_status = ''C''