APPS.PAY_AU_TERM_REP dependencies on PAY_ASSIGNMENT_ACTIONS

Line 97: pay_assignment_Actions paa

93: pay_run_result_values prrv,
94: pay_input_values_f piv,
95: pay_element_types_f pet,
96: pay_run_results prr,
97: pay_assignment_Actions paa
98: where
99: prrv.input_value_id=piv.input_value_id
100: and piv.element_type_id=pet.element_type_id
101: and prr.element_type_id = pet.element_type_id

Line 124: pay_assignment_Actions paa

120: pay_run_result_values prrv,
121: pay_input_values_f piv,
122: pay_element_types_f pet,
123: pay_run_results prr,
124: pay_assignment_Actions paa
125: where
126: prrv.input_value_id=piv.input_value_id
127: and piv.element_type_id=pet.element_type_id
128: and prr.element_type_id = pet.element_type_id

Line 145: pay_assignment_actions paa2,

141: from pay_run_results prr2,
142: pay_input_values_f piv2,
143: pay_element_entries_f pee2,
144: pay_run_result_values prrv2,
145: pay_assignment_actions paa2,
146: pay_run_results prr3
147: where
148: prr2.element_type_id = pee2.element_type_id and
149: piv2.element_type_id = pee2.element_type_id and

Line 307: pay_assignment_Actions paa

303: pay_run_result_values prrv,
304: pay_input_values_f piv,
305: pay_element_types_f pet,
306: pay_run_results prr,
307: pay_assignment_Actions paa
308: where
309: prrv.input_value_id=piv.input_value_id
310: and piv.element_type_id=pet.element_type_id
311: and prr.element_type_id = pet.element_type_id

Line 332: pay_assignment_Actions paa

328: pay_run_result_values prrv,
329: pay_input_values_f piv,
330: pay_element_types_f pet,
331: pay_run_results prr,
332: pay_assignment_Actions paa
333: where
334: prrv.input_value_id=piv.input_value_id
335: and piv.element_type_id=pet.element_type_id
336: and prr.element_type_id = pet.element_type_id

Line 353: pay_assignment_actions paa2,

349: from pay_run_results prr2,
350: pay_input_values_f piv2,
351: pay_element_entries_f pee2,
352: pay_run_result_values prrv2,
353: pay_assignment_actions paa2,
354: pay_run_results prr3
355: where
356: prr2.element_type_id = pee2.element_type_id and
357: piv2.element_type_id = pee2.element_type_id and

Line 372: ,pay_assignment_actions paa

368:
369:
370: cursor get_date_earned is select date_earned
371: from pay_payroll_actions ppa
372: ,pay_assignment_actions paa
373: where paa.assignment_action_id=p_assignment_action_id
374: and paa.payroll_action_id=ppa.payroll_action_id;
375: begin
376:

Line 611: ,pay_assignment_actions paa

607: /* 6470561 */
608:
609: cursor get_date_earned is select date_earned
610: from pay_payroll_actions ppa
611: ,pay_assignment_actions paa
612: where paa.assignment_action_id=p_assignment_action_id
613: and paa.payroll_action_id=ppa.payroll_action_id;
614:
615: begin