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_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 2729: FROM pay_assignment_actions paa

2725: CURSOR get_assignment_pact_id
2726: IS
2727: SELECT paa.assignment_id
2728: ,paa.payroll_action_id
2729: FROM pay_assignment_actions paa
2730: ,per_all_assignments_f paf
2731: WHERE paa.assignment_action_id = p_assignment_action_id
2732: AND paa.assignment_id = paf.assignment_id
2733: AND ROWNUM =1;

Line 2742: ,pay_assignment_actions paa

2738: ,LEAST(asg.effective_end_date,g_end_date) end_date
2739: ,scl.segment1
2740: FROM per_all_assignments_f asg
2741: ,hr_soft_coding_keyflex scl
2742: ,pay_assignment_actions paa
2743: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2744: AND paa.assignment_action_id = p_assignment_action_id
2745: AND asg.assignment_id = paa.assignment_id
2746: AND scl.segment1 LIKE TO_CHAR(g_gre_id)

Line 2760: FROM pay_assignment_actions paa

2756: ,p_assignment_id NUMBER
2757: )
2758: IS
2759: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
2760: FROM pay_assignment_actions paa
2761: ,pay_payroll_actions ppa
2762: ,per_assignments_f paf
2763: WHERE paf.assignment_id = paa.assignment_id
2764: AND paf.assignment_id = p_assignment_id

Line 2775: pay_assignment_actions paa1,

2771: AND ppa.payroll_id = paf.payroll_id
2772: AND (1 = DECODE(ppa.action_type,'I',1,0)
2773: OR EXISTS (SELECT ''
2774: FROM pay_action_interlocks intk,
2775: pay_assignment_actions paa1,
2776: pay_payroll_actions ppa1
2777: WHERE intk.locked_action_id = paa.assignment_Action_id
2778: AND intk.locking_action_id = paa1.assignment_action_id
2779: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 2791: pay_assignment_actions paa

2787: CURSOR c_get_date_earned(l_run_assact NUMBER)
2788: IS
2789: SELECT ppa.date_earned run_date
2790: FROM pay_payroll_actions ppa,
2791: pay_assignment_actions paa
2792: WHERE paa.payroll_action_id = ppa.payroll_action_id
2793: AND paa.assignment_action_id = l_run_assact;
2794:
2795: CURSOR get_prepayment_date(l_run_assact NUMBER)

Line 2799: pay_assignment_actions paa,

2795: CURSOR get_prepayment_date(l_run_assact NUMBER)
2796: IS
2797: SELECT ppa.effective_date
2798: FROM pay_payroll_actions ppa,
2799: pay_assignment_actions paa,
2800: pay_action_interlocks intk
2801: WHERE intk.locked_action_id = l_run_assact
2802: AND intk.locking_action_id =paa.assignment_action_id
2803: AND ppa.payroll_action_id = paa.payroll_action_id