APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 74: , pay_assignment_actions paa

70:
71: CURSOR get_context(p_assignment_id NUMBER) IS
72: SELECT max(paa.ASSIGNMENT_ACTION_ID)
73: FROM pay_payroll_actions ppa
74: , pay_assignment_actions paa
75: WHERE paa.assignment_id = p_assignment_id
76: AND paa.payroll_action_id = ppa.payroll_action_id
77: AND ppa.action_type IN('P','U');
78:

Line 96: , pay_assignment_actions paa

92: /* Added nvl for bug 5879516 */
93: CURSOR get_context(p_assignment_id NUMBER) IS
94: SELECT max(ppa.DATE_EARNED)
95: FROM pay_payroll_actions ppa
96: , pay_assignment_actions paa
97: WHERE paa.assignment_id = p_assignment_id
98: AND paa.payroll_action_id = ppa.payroll_action_id
99: AND ppa.action_type IN('P','U');
100:

Line 105: , pay_assignment_actions paa

101: /*Added for bug 5930673 */
102: Cursor get_alternate_date_earned (p_assignment_id NUMBER) IS
103: SELECT max(nvl(ppa.date_earned,ppar.date_earned))
104: FROM pay_payroll_actions ppa
105: , pay_assignment_actions paa
106: , pay_action_interlocks pail
107: , pay_payroll_actions ppar
108: , pay_assignment_actions paar
109: WHERE paa.assignment_id = p_assignment_id

Line 108: , pay_assignment_actions paar

104: FROM pay_payroll_actions ppa
105: , pay_assignment_actions paa
106: , pay_action_interlocks pail
107: , pay_payroll_actions ppar
108: , pay_assignment_actions paar
109: WHERE paa.assignment_id = p_assignment_id
110: AND paa.payroll_action_id = ppa.payroll_action_id
111: AND paar.assignment_action_id = pail.locked_action_id
112: AND pail.locking_action_id = paa.assignment_action_id

Line 144: , pay_assignment_actions paa

140:
141: CURSOR get_ass_action_id(p_assignment_id NUMBER) IS
142: SELECT ppp.assignment_action_id
143: FROM pay_payroll_actions ppa
144: , pay_assignment_actions paa
145: , pay_action_interlocks pai
146: , pay_pre_payments ppp
147: WHERE paa.assignment_id = p_assignment_id
148: AND paa.payroll_action_id = ppa.payroll_action_id

Line 196: , pay_assignment_actions paa

192:
193: CURSOR get_context(p_assignment_id NUMBER) IS
194: SELECT ppa.date_earned
195: FROM pay_payroll_actions ppa
196: , pay_assignment_actions paa
197: , pay_action_interlocks pai
198: WHERE paa.assignment_id = p_assignment_id
199: AND paa.payroll_action_id = ppa.payroll_action_id
200: AND ppa.action_type = 'M'

Line 246: , pay_assignment_actions paa

242: , pay_run_result_values prrv4
243: , pay_element_types_f pet2
244: , pay_input_values_f piv2
245: , pay_input_values_f piv4
246: , pay_assignment_actions paa
247: , pay_payroll_actions ppa
248: , pay_element_entries_f pee
249: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
250: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID

Line 296: , pay_assignment_actions paa

292:
293: CURSOR get_is_record_01_details_local IS
294: SELECT '1'
295: FROM pay_payroll_actions ppa
296: , pay_assignment_actions paa
297: , pay_element_entries_f pee1
298: , pay_element_types_f pet
299: , pay_element_entries_f pee2
300: , hr_organization_units hou /*bug fix 4551283*/

Line 340: , pay_assignment_actions paa

336:
337: CURSOR get_is_record_02_details_local IS
338: SELECT '1'
339: FROM pay_payroll_actions ppa
340: , pay_assignment_actions paa
341: , pay_element_entries_f pee1
342: , pay_element_types_f pet
343: , pay_element_entries_f pee2
344: /* Added for Pension changes */

Line 379: , pay_assignment_actions paa

375:
376: CURSOR get_is_record_03_details_local IS
377: SELECT '1'
378: FROM pay_payroll_actions ppa
379: , pay_assignment_actions paa
380: , pay_element_entries_f pee1
381: , pay_element_types_f pet
382: , pay_element_entries_f pee2
383: /* Added for Pension changes */