APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 152: , pay_assignment_actions paa

148: CURSOR csr_asg_act_id
149: IS
150: SELECT max(paa.ASSIGNMENT_ACTION_ID)
151: FROM pay_payroll_actions ppa
152: , pay_assignment_actions paa
153: WHERE paa.assignment_id = p_assignment_id
154: AND paa.payroll_action_id = ppa.payroll_action_id
155: AND paa.action_status IN ('C','S') -- 10229494
156: AND ppa.action_type IN('R','Q','I','B','V','P','U');

Line 158: l_asg_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE;

154: AND paa.payroll_action_id = ppa.payroll_action_id
155: AND paa.action_status IN ('C','S') -- 10229494
156: AND ppa.action_type IN('R','Q','I','B','V','P','U');
157:
158: l_asg_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE;
159: BEGIN
160: OPEN csr_asg_act_id;
161: FETCH csr_asg_act_id INTO l_asg_action_id;
162: CLOSE csr_asg_act_id;

Line 325: , pay_assignment_actions paa

321:
322: CURSOR get_context(p_assignment_id NUMBER) IS
323: SELECT max(paa.ASSIGNMENT_ACTION_ID)
324: FROM pay_payroll_actions ppa
325: , pay_assignment_actions paa
326: WHERE paa.assignment_id = p_assignment_id
327: AND paa.payroll_action_id = ppa.payroll_action_id
328: AND ppa.action_type IN('P','U');
329:

Line 347: , pay_assignment_actions paa

343: /* Added nvl for bug 5879516 */
344: CURSOR get_context(p_assignment_id NUMBER) IS
345: SELECT max(ppa.DATE_EARNED)
346: FROM pay_payroll_actions ppa
347: , pay_assignment_actions paa
348: WHERE paa.assignment_id = p_assignment_id
349: AND paa.payroll_action_id = ppa.payroll_action_id
350: AND ppa.action_type IN('P','U');
351:

Line 356: , pay_assignment_actions paa

352: /*Added for bug 5930673 */
353: Cursor get_alternate_date_earned (p_assignment_id NUMBER) IS
354: SELECT max(nvl(ppa.date_earned,ppar.date_earned))
355: FROM pay_payroll_actions ppa
356: , pay_assignment_actions paa
357: , pay_action_interlocks pail
358: , pay_payroll_actions ppar
359: , pay_assignment_actions paar
360: WHERE paa.assignment_id = p_assignment_id

Line 359: , pay_assignment_actions paar

355: FROM pay_payroll_actions ppa
356: , pay_assignment_actions paa
357: , pay_action_interlocks pail
358: , pay_payroll_actions ppar
359: , pay_assignment_actions paar
360: WHERE paa.assignment_id = p_assignment_id
361: AND paa.payroll_action_id = ppa.payroll_action_id
362: AND paar.assignment_action_id = pail.locked_action_id
363: AND pail.locking_action_id = paa.assignment_action_id

Line 395: , pay_assignment_actions paa

391:
392: CURSOR get_ass_action_id(p_assignment_id NUMBER) IS
393: SELECT ppp.assignment_action_id
394: FROM pay_payroll_actions ppa
395: , pay_assignment_actions paa
396: , pay_action_interlocks pai
397: , pay_pre_payments ppp
398: WHERE paa.assignment_id = p_assignment_id
399: AND paa.payroll_action_id = ppa.payroll_action_id

Line 447: , pay_assignment_actions paa

443:
444: CURSOR get_context(p_assignment_id NUMBER) IS
445: SELECT ppa.date_earned
446: FROM pay_payroll_actions ppa
447: , pay_assignment_actions paa
448: , pay_action_interlocks pai
449: WHERE paa.assignment_id = p_assignment_id
450: AND paa.payroll_action_id = ppa.payroll_action_id
451: AND ppa.action_type = 'M'

Line 503: , pay_assignment_actions paa

499: , pay_run_result_values prrv4
500: , pay_element_types_f pet2
501: , pay_input_values_f piv2
502: , pay_input_values_f piv4
503: , pay_assignment_actions paa
504: , pay_payroll_actions ppa
505: , pay_element_entries_f pee
506: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
507: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID

Line 553: , pay_assignment_actions paa

549:
550: CURSOR get_is_record_01_details_local IS
551: SELECT '1'
552: FROM pay_payroll_actions ppa
553: , pay_assignment_actions paa
554: , pay_element_entries_f pee1
555: , pay_element_types_f pet
556: , pay_element_entries_f pee2
557: , hr_organization_units hou /*bug fix 4551283*/

Line 597: , pay_assignment_actions paa

593:
594: CURSOR get_is_record_02_details_local IS
595: SELECT '1'
596: FROM pay_payroll_actions ppa
597: , pay_assignment_actions paa
598: , pay_element_entries_f pee1
599: , pay_element_types_f pet
600: , pay_element_entries_f pee2
601: /* Added for Pension changes */

Line 637: , pay_assignment_actions paa

633:
634: CURSOR get_is_record_03_details_local IS
635: SELECT '1'
636: FROM pay_payroll_actions ppa
637: , pay_assignment_actions paa
638: , pay_element_entries_f pee1
639: , pay_element_types_f pet
640: , pay_element_entries_f pee2
641: /* Added for Pension changes */