APPS.PAY_GB_P11D_MAGTAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 88: FROM pay_assignment_actions paa, pay_action_information pai

84: pay_gb_p11d_magtape.get_parameters(
85: pay_magtape_generic.get_parameter_value(
86: 'ARCH_PAYROLL_ACTION_ID'),
87: 'PARTY_NAME')
88: FROM pay_assignment_actions paa, pay_action_information pai
89: WHERE paa.payroll_action_id =
90: pay_magtape_generic.get_parameter_value(
91: 'ARCH_PAYROLL_ACTION_ID')
92: AND pai.action_context_id = paa.assignment_action_id

Line 135: FROM pay_assignment_actions paa,

131: 'ADDRESS_LINE_4=P',
132: NVL(pai_person.action_information8, ' '),
133: 'ADDRESS_LINE_5=P',
134: NVL(hl.meaning, ' ')
135: FROM pay_assignment_actions paa,
136: pay_action_information pai,
137: pay_action_information pai_emp,
138: pay_action_information pai_gb,
139: pay_action_information pai_person,

Line 195: FROM pay_assignment_actions paa,

191: 'VOUCHERS OR CREDIT CARDS', 'C',
192: 'CAERS', 'U',
193: 'OTHER ITEMS NON 1A', 'N',
194: 'CAR AND CAR FUEL 2003_04', 'F') cat_order
195: FROM pay_assignment_actions paa,
196: pay_action_information pai_person,
197: pay_action_information pai_comp,
198: pay_action_information pai
199: WHERE paa.payroll_action_id =

Line 702: FROM pay_assignment_actions paa,

698: DECODE(
699: pai.action_information_category,
700: 'TAXABLE EXPENSE PAYMENTS', pai.action_information9,
701: '0') )
702: FROM pay_assignment_actions paa,
703: pay_action_information pai_person,
704: pay_action_information pai_comp,
705: pay_action_information pai_resultA,
706: pay_action_information pai