eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 32: From Pay_Payroll_Actions

28: l_QTR_END VARCHAR2(10);
29:
30: CURSOR C_Payroll_id IS
31: Select payroll_id, effective_date
32: From Pay_Payroll_Actions
33: Where Payroll_Action_Id = p_payroll_action_id;
34:
35: Cursor c_atp_tax_info(p_payroll_id NUMBER) IS
36: SELECT NVL(MAX(action_information2) + 1,'60')

Line 102: From Pay_Payroll_Actions

98:
99:
100: CURSOR C_Payroll_id IS
101: Select payroll_id
102: From Pay_Payroll_Actions
103: Where Payroll_Action_Id = p_payroll_action_id;
104:
105: BEGIN
106:

Line 151: FROM pay_payroll_actions ppa

147: AS
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

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

205: p_parameter_string IN VARCHAR2
206: ,p_token IN VARCHAR2
207: ,p_segment_number IN NUMBER DEFAULT NULL ) RETURN VARCHAR2
208: IS
209: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
210: l_start_pos NUMBER;
211: l_delimiter varchar2(1);
212: l_proc VARCHAR2(60);
213: BEGIN

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

243: -----------------------------------------------------------------------------
244: FUNCTION get_parameters(p_payroll_action_id NUMBER,
245: p_token IN VARCHAR2) RETURN VARCHAR2
246: IS
247: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
248: l_start_pos NUMBER;
249: l_delimiter varchar2(1);
250: l_proc VARCHAR2(60);
251:

Line 252: p_parameter_string pay_payroll_actions.legislative_parameters%TYPE;

248: l_start_pos NUMBER;
249: l_delimiter varchar2(1);
250: l_proc VARCHAR2(60);
251:
252: p_parameter_string pay_payroll_actions.legislative_parameters%TYPE;
253: p_segment_number NUMBER;
254:
255: CURSOR C_leg_string
256: IS

Line 258: FROM PAY_PAYROLL_ACTIONS

254:
255: CURSOR C_leg_string
256: IS
257: SELECT legislative_parameters
258: FROM PAY_PAYROLL_ACTIONS
259: WHERE payroll_action_id = p_payroll_action_id;
260:
261: BEGIN
262: l_delimiter :=' ';

Line 324: FROM pay_payroll_actions ppa

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

Line 346: FROM pay_payroll_actions ppa

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

Line 355: FROM pay_payroll_actions ppa

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

Line 358: , pay_payroll_actions ppar

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

Line 394: FROM pay_payroll_actions ppa

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

Line 446: FROM pay_payroll_actions ppa

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

Line 476: , pay_payroll_actions ppa

472: SELECT '1'
473: FROM per_addresses pad
474: /* Modified for bug fix 4593682 */
475: , per_all_people_f pap
476: , pay_payroll_actions ppa
477: WHERE /*pad.person_id = p_person_id*/
478: pad.person_id (+)= pap.person_id
479: AND pad.primary_flag = 'Y' --9403004
480: AND ppa.effective_date BETWEEN nvl(pad.date_from,ppa.effective_date) AND nvl(pad.date_to,to_date('31-12-4712','dd-mm-rrrr')) --9403004

Line 504: , pay_payroll_actions ppa

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

Line 552: FROM pay_payroll_actions ppa

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

Line 596: FROM pay_payroll_actions ppa

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

Line 636: FROM pay_payroll_actions ppa

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

Line 892: FROM PAY_PAYROLL_ACTIONS ppa

888: AND p_date_earned BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE;
889:
890: CURSOR get_payroll_id (p_payroll_action_id NUMBER ) IS
891: SELECT PAYROLL_ID
892: FROM PAY_PAYROLL_ACTIONS ppa
893: WHERE payroll_action_id = p_payroll_action_id;
894:
895:
896: BEGIN

Line 916: pay_payroll_actions PACTION

912: Cursor csr_pay_period (p_payroll_action_id NUMBER , p_date_earned DATE) is
913: Select
914: TPTYPE.number_per_fiscal_year
915: from
916: pay_payroll_actions PACTION
917: , per_time_periods TPERIOD
918: , per_time_period_types TPTYPE
919: where PACTION.payroll_action_id = p_payroll_action_id
920: and TPERIOD.payroll_id = PACTION.payroll_id