APPS.PAY_AU_TERM_REP dependencies on PAY_ASSIGNMENT_ACTIONS

Line 116: pay_assignment_Actions paa

112: pay_run_result_values prrv,
113: pay_input_values_f piv,
114: pay_element_types_f pet,
115: pay_run_results prr,
116: pay_assignment_Actions paa
117: where
118: prrv.input_value_id=piv.input_value_id
119: and piv.element_type_id=pet.element_type_id
120: and prr.element_type_id = pet.element_type_id

Line 142: pay_assignment_Actions paa

138: pay_run_result_values prrv,
139: pay_input_values_f piv,
140: pay_element_types_f pet,
141: pay_run_results prr,
142: pay_assignment_Actions paa
143: where
144: prrv.input_value_id=piv.input_value_id
145: and piv.element_type_id=pet.element_type_id
146: and prr.element_type_id = pet.element_type_id

Line 162: pay_assignment_actions paa2,

158: from pay_run_results prr2,
159: pay_input_values_f piv2,
160: pay_element_entries_f pee2,
161: pay_run_result_values prrv2,
162: pay_assignment_actions paa2,
163: pay_run_results prr3
164: where
165: prr2.element_type_id = pee2.element_type_id and
166: piv2.element_type_id = pee2.element_type_id and

Line 388: pay_assignment_Actions paa

384: pay_run_result_values prrv,
385: pay_input_values_f piv,
386: pay_element_types_f pet,
387: pay_run_results prr,
388: pay_assignment_Actions paa
389: where
390: prrv.input_value_id=piv.input_value_id
391: and piv.element_type_id=pet.element_type_id
392: and prr.element_type_id = pet.element_type_id

Line 412: pay_assignment_Actions paa

408: pay_run_result_values prrv,
409: pay_input_values_f piv,
410: pay_element_types_f pet,
411: pay_run_results prr,
412: pay_assignment_Actions paa
413: where
414: prrv.input_value_id=piv.input_value_id
415: and piv.element_type_id=pet.element_type_id
416: and prr.element_type_id = pet.element_type_id

Line 432: pay_assignment_actions paa2,

428: from pay_run_results prr2,
429: pay_input_values_f piv2,
430: pay_element_entries_f pee2,
431: pay_run_result_values prrv2,
432: pay_assignment_actions paa2,
433: pay_run_results prr3
434: where
435: prr2.element_type_id = pee2.element_type_id and
436: piv2.element_type_id = pee2.element_type_id and

Line 453: pay_assignment_actions paa,

449: pay_run_result_values prrv,
450: pay_input_values_f piv,
451: pay_element_types_f pet,
452: pay_run_results prr,
453: pay_assignment_actions paa,
454: pay_element_entries_f pee,
455: pay_element_types_f pet2
456: where
457: prrv.input_value_id=piv.input_value_id

Line 479: ,pay_assignment_actions paa

475:
476:
477: cursor get_date_earned is select date_earned
478: from pay_payroll_actions ppa
479: ,pay_assignment_actions paa
480: where paa.assignment_action_id=p_assignment_action_id
481: and paa.payroll_action_id=ppa.payroll_action_id;
482: begin
483:

Line 809: ,pay_assignment_actions paa

805: /* 6470561 */
806:
807: cursor get_date_earned is select date_earned
808: from pay_payroll_actions ppa
809: ,pay_assignment_actions paa
810: where paa.assignment_action_id=p_assignment_action_id
811: and paa.payroll_action_id=ppa.payroll_action_id;
812:
813: begin

Line 889: ,pay_assignment_actions paa

885:
886: cursor get_date_earned is
887: select date_earned
888: from pay_payroll_actions ppa
889: ,pay_assignment_actions paa
890: where paa.assignment_action_id = p_assignment_action_id
891: and paa.payroll_action_id = ppa.payroll_action_id;
892:
893: