APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 17: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

13: p_parameter_string IN VARCHAR2
14: ,p_token IN VARCHAR2
15: ,p_segment_number IN NUMBER DEFAULT NULL ) RETURN VARCHAR2
16: IS
17: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
18: l_start_pos NUMBER;
19: l_delimiter varchar2(1);
20: l_proc VARCHAR2(60);
21: BEGIN

Line 73: FROM pay_payroll_actions ppa

69: l_context NUMBER;
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');

Line 95: FROM pay_payroll_actions ppa

91: l_context DATE;
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');

Line 104: FROM pay_payroll_actions ppa

100:
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

Line 107: , pay_payroll_actions ppar

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
110: AND paa.payroll_action_id = ppa.payroll_action_id
111: AND paar.assignment_action_id = pail.locked_action_id

Line 143: FROM pay_payroll_actions ppa

139: l_value NUMBER;
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

Line 195: FROM pay_payroll_actions ppa

191: l_context DATE;
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

Line 247: , pay_payroll_actions ppa

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
251: AND prrv1.RUN_RESULT_ID = prr1.RUN_RESULT_ID

Line 295: FROM pay_payroll_actions ppa

291: /* Cursors IS 01 to 03 also included and re-written as they too use TRANSFER_ASSIGNMENT_ID for bug fix 4567621 */
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

Line 339: FROM pay_payroll_actions ppa

335:
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

Line 378: FROM pay_payroll_actions ppa

374:
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

Line 633: FROM PAY_PAYROLL_ACTIONS ppa

629: AND p_date_earned BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE;
630:
631: CURSOR get_payroll_id (p_payroll_action_id NUMBER ) IS
632: SELECT PAYROLL_ID
633: FROM PAY_PAYROLL_ACTIONS ppa
634: WHERE payroll_action_id = p_payroll_action_id;
635:
636:
637: BEGIN

Line 657: pay_payroll_actions PACTION

653: Cursor csr_pay_period (p_payroll_action_id NUMBER , p_date_earned DATE) is
654: Select
655: TPTYPE.number_per_fiscal_year
656: from
657: pay_payroll_actions PACTION
658: , per_time_periods TPERIOD
659: , per_time_period_types TPTYPE
660: where PACTION.payroll_action_id = p_payroll_action_id
661: and TPERIOD.payroll_id = PACTION.payroll_id