DBA Data[Home] [Help]

APPS.PAY_IN_EOY_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 440: ,pay_assignment_actions paa

436: IS
437: SELECT paf.assignment_id assignment_id
438: FROM per_assignments_f paf
439: ,pay_payroll_actions ppa
440: ,pay_assignment_actions paa
441: WHERE paf.business_group_id = g_bg_id
442: AND paf.person_id BETWEEN p_start_person AND p_end_person
443: AND p_payroll_action_id IS NOT NULL
444: AND paa.tax_unit_id LIKE g_gre_id

Line 508: SELECT pay_assignment_actions_s.NEXTVAL

504: ,p_assignment_id => csr_rec.assignment_id
505: ,p_gre_id => g_gre_id);
506: IF (l_flag = TRUE) THEN
507: pay_in_utils.set_location(g_debug,l_procedure, 50);
508: SELECT pay_assignment_actions_s.NEXTVAL
509: INTO l_action_id
510: FROM dual;
511:
512: hr_nonrun_asact.insact(lockingactid => l_action_id

Line 2634: FROM pay_assignment_actions paa

2630: CURSOR get_assignment_pact_id
2631: IS
2632: SELECT paa.assignment_id
2633: ,paa.payroll_action_id
2634: FROM pay_assignment_actions paa
2635: ,per_all_assignments_f paf
2636: WHERE paa.assignment_action_id = p_assignment_action_id
2637: AND paa.assignment_id = paf.assignment_id
2638: AND ROWNUM =1;

Line 2647: ,pay_assignment_actions paa

2643: ,LEAST(asg.effective_end_date,g_end_date) end_date
2644: ,scl.segment1
2645: FROM per_all_assignments_f asg
2646: ,hr_soft_coding_keyflex scl
2647: ,pay_assignment_actions paa
2648: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2649: AND paa.assignment_action_id = p_assignment_action_id
2650: AND asg.assignment_id = paa.assignment_id
2651: AND scl.segment1 LIKE TO_CHAR(g_gre_id)

Line 2665: FROM pay_assignment_actions paa

2661: ,p_assignment_id NUMBER
2662: )
2663: IS
2664: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
2665: FROM pay_assignment_actions paa
2666: ,pay_payroll_actions ppa
2667: ,per_assignments_f paf
2668: WHERE paf.assignment_id = paa.assignment_id
2669: AND paf.assignment_id = p_assignment_id

Line 2680: pay_assignment_actions paa1,

2676: AND ppa.payroll_id = paf.payroll_id
2677: AND (1 = DECODE(ppa.action_type,'I',1,0)
2678: OR EXISTS (SELECT ''
2679: FROM pay_action_interlocks intk,
2680: pay_assignment_actions paa1,
2681: pay_payroll_actions ppa1
2682: WHERE intk.locked_action_id = paa.assignment_Action_id
2683: AND intk.locking_action_id = paa1.assignment_action_id
2684: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 2696: pay_assignment_actions paa

2692: CURSOR c_get_date_earned(l_run_assact NUMBER)
2693: IS
2694: SELECT ppa.date_earned run_date
2695: FROM pay_payroll_actions ppa,
2696: pay_assignment_actions paa
2697: WHERE paa.payroll_action_id = ppa.payroll_action_id
2698: AND paa.assignment_action_id = l_run_assact;
2699:
2700: CURSOR get_prepayment_date(l_run_assact NUMBER)

Line 2704: pay_assignment_actions paa,

2700: CURSOR get_prepayment_date(l_run_assact NUMBER)
2701: IS
2702: SELECT ppa.effective_date
2703: FROM pay_payroll_actions ppa,
2704: pay_assignment_actions paa,
2705: pay_action_interlocks intk
2706: WHERE intk.locked_action_id = l_run_assact
2707: AND intk.locking_action_id =paa.assignment_action_id
2708: AND ppa.payroll_action_id = paa.payroll_action_id