[Home] [Help]
221: pai.action_information12 SENDER_ID,
222: pai.action_information13 TEST_INDICATOR,
223: pai.action_information14 HEADER_VALUE
224: from pay_payroll_actions ppa,
225: pay_action_information pai
226: where ppa.payroll_action_id = c_arch_pay_action_id
227: and ppa.payroll_action_id = pai.action_context_id
228: and pai.action_information_category='RTI PAYROLL INFO'
229: and pai.action_context_type='PA';
371: pai.action_information12 SENDER_ID,
372: pai.action_information13 TEST_INDICATOR,
373: pai.action_information14 HEADER_VALUE
374: from pay_payroll_actions ppa,
375: pay_action_information pai
376: where ppa.payroll_action_id = c_arch_pay_action_id
377: and ppa.payroll_action_id = pai.action_context_id
378: and pai.action_information_category='RTI PAYROLL INFO'
379: and pai.action_context_type='PA';
583: c_arch_pay_action_id number) is
584: select paa_arch.assignment_action_id
585: from pay_assignment_actions paa_arch,
586: pay_assignment_actions paa_mag,
587: pay_action_information pai
588: where paa_mag.payroll_action_id = c_mag_payroll_actid
589: and paa_mag.assignment_action_id = c_mag_asg_action_id
590: and paa_arch.payroll_action_id = c_arch_pay_action_id
591:
634: pai_empl.action_information7,
635: pai_empl.action_information8,
636: pai_empl.action_information9
637:
638: from pay_action_information pai_addr,
639: pay_action_information pai_empl
640: where pai_addr.action_context_id = c_arch_asg_action_id
641: and pai_addr.action_information_category = 'ADDRESS DETAILS'
642: and pai_addr.action_context_type = 'AAP'
635: pai_empl.action_information8,
636: pai_empl.action_information9
637:
638: from pay_action_information pai_addr,
639: pay_action_information pai_empl
640: where pai_addr.action_context_id = c_arch_asg_action_id
641: and pai_addr.action_information_category = 'ADDRESS DETAILS'
642: and pai_addr.action_context_type = 'AAP'
643: and pai_empl.action_context_id = c_arch_asg_action_id
653: pai_asg.ACTION_INFORMATION5,
654: pai_asg.ACTION_INFORMATION6,
655: pai_asg.ACTION_INFORMATION7,
656: pai_asg.ACTION_INFORMATION8
657: from pay_action_information pai_asg
658: where pai_asg.action_context_id = c_arch_asg_action_id
659: and pai_asg.action_information_category = 'GB RTI ASG DETAILS'
660: and pai_asg.action_context_type = 'AAP';
661:
965: c_arch_pay_action_id number) is
966: select paa_arch.assignment_action_id
967: from pay_assignment_actions paa_arch,
968: pay_assignment_actions paa_mag,
969: pay_action_information pai
970: where paa_mag.payroll_action_id = c_mag_payroll_actid
971: and paa_mag.assignment_action_id = c_mag_asg_action_id
972: and paa_arch.payroll_action_id = c_arch_pay_action_id
973:
995: pai_empl.action_information7,
996: pai_empl.action_information8,
997: pai_empl.action_information9
998:
999: from pay_action_information pai_addr,
1000: pay_action_information pai_empl
1001: where pai_addr.action_context_id = c_arch_asg_action_id
1002: and pai_addr.action_information_category = 'ADDRESS DETAILS'
1003: and pai_addr.action_context_type = 'AAP'
996: pai_empl.action_information8,
997: pai_empl.action_information9
998:
999: from pay_action_information pai_addr,
1000: pay_action_information pai_empl
1001: where pai_addr.action_context_id = c_arch_asg_action_id
1002: and pai_addr.action_information_category = 'ADDRESS DETAILS'
1003: and pai_addr.action_context_type = 'AAP'
1004: and pai_empl.action_context_id = c_arch_asg_action_id
1139:
1140: cursor csr_asg (c_arch_payroll_action_id number) is
1141: select distinct paa.assignment_id
1142: from pay_assignment_actions paa,
1143: pay_action_information pai,
1144: per_all_assignments_f paaf
1145: where paa.payroll_action_id = c_arch_payroll_action_id
1146: and pai.action_context_id = paa.assignment_action_id
1147: -- and pai.action_information_category = 'GB_RTI_ASG_DETAILS'