APPS.PAY_GB_RTI_FPS_OUTPUT dependencies on PAY_ACTION_INFORMATION

Line 150: pay_action_information pai

146: pai.action_information7,
147: pai.action_information8,
148: pai.action_information9
149: from pay_payroll_actions ppa,
150: pay_action_information pai
151: where ppa.payroll_action_id = c_arch_pay_action_id
152: and ppa.payroll_action_id = pai.action_context_id
153: and pai.action_information_category='GB_RTI_FPS_EXTRA_DET'
154: and pai.action_context_type='PA';

Line 290: pay_action_information pai

286: pai.action_information13 TEST_INDICATOR,
287: pai.action_information14 HEADER_VALUE,
288: pai.action_information15 TAX_YEAR
289: from pay_payroll_actions ppa,
290: pay_action_information pai
291: where ppa.payroll_action_id = c_arch_pay_action_id
292: and ppa.payroll_action_id = pai.action_context_id
293: and pai.action_information_category='RTI PAYROLL INFO'
294: and pai.action_context_type='PA';

Line 621: pay_action_information pai

617: c_arch_pay_action_id number) is
618: select paa_arch.assignment_action_id
619: from pay_assignment_actions paa_arch,
620: pay_assignment_actions paa_mag,
621: pay_action_information pai
622: where paa_mag.payroll_action_id = c_mag_payroll_actid
623: and paa_mag.assignment_action_id = c_mag_asg_action_id
624: and paa_arch.payroll_action_id = c_arch_pay_action_id
625:

Line 680: from pay_action_information pai_addr,

676: pai_empl.action_information13,
677: pai_empl.action_information14,
678: pai_empl.action_information15
679:
680: from pay_action_information pai_addr,
681: pay_action_information pai_empl
682: where pai_addr.action_context_id = c_arch_asg_action_id
683: and pai_addr.action_information_category = 'ADDRESS DETAILS'
684: and pai_addr.action_context_type = 'AAP'

Line 681: pay_action_information pai_empl

677: pai_empl.action_information14,
678: pai_empl.action_information15
679:
680: from pay_action_information pai_addr,
681: pay_action_information pai_empl
682: where pai_addr.action_context_id = c_arch_asg_action_id
683: and pai_addr.action_information_category = 'ADDRESS DETAILS'
684: and pai_addr.action_context_type = 'AAP'
685: and pai_empl.action_context_id = c_arch_asg_action_id

Line 721: from pay_action_information pai_asg

717: pai_asg.ACTION_INFORMATION25,
718: pai_asg.ACTION_INFORMATION26,
719: pai_asg.ACTION_INFORMATION28
720:
721: from pay_action_information pai_asg
722: where pai_asg.action_context_id = c_arch_asg_action_id
723: and pai_asg.action_information_category = 'GB_RTI_FPS_ASG_DET1'
724: and pai_asg.action_context_type = 'AAP';
725:

Line 750: from pay_action_information pai_asg

746: pai_asg.ACTION_INFORMATION22,
747: pai_asg.ACTION_INFORMATION25,
748: pai_asg.ACTION_INFORMATION27
749:
750: from pay_action_information pai_asg
751: where pai_asg.action_context_id = c_arch_asg_action_id
752: and pai_asg.action_information_category = 'GB_RTI_FPS_ASG_DET2'
753: and pai_asg.action_context_type = 'AAP';
754:

Line 769: from pay_action_information where action_context_id = l_arch_asg_action_id

765: ACTION_INFORMATION7,
766: ACTION_INFORMATION8,
767: ACTION_INFORMATION9,
768: ACTION_INFORMATION10
769: from pay_action_information where action_context_id = l_arch_asg_action_id
770: and ACTION_INFORMATION_CATEGORY = 'GB_RTI_FPS_NI_DET'
771: and ACTION_CONTEXT_TYPE = 'AAP';
772:
773:

Line 1620: pay_action_information pai,

1616:
1617: cursor csr_asg (c_arch_payroll_action_id number) is
1618: select distinct paa.assignment_id
1619: from pay_assignment_actions paa,
1620: pay_action_information pai,
1621: per_all_assignments_f paaf
1622: where paa.payroll_action_id = c_arch_payroll_action_id
1623: and pai.action_context_id = paa.assignment_action_id
1624: and pai.action_information_category = 'GB_RTI_FPS_ASG_DET1'