APPS.PAY_IN_UTILS dependencies on PAY_PAYROLL_ACTIONS

Line 29: ,pay_payroll_actions ppa

25: CURSOR c_max_act_seq
26: IS
27: SELECT MAX(paa.action_sequence)
28: FROM pay_assignment_actions paa
29: ,pay_payroll_actions ppa
30: WHERE paa.payroll_action_id = ppa.payroll_action_id
31: AND ppa.action_type = p_process_type
32: AND paa.assignment_id = p_assignment_id
33: AND TRUNC(ppa.effective_date,'MM') = TRUNC(p_effective_date,'MM');

Line 376: pay_payroll_actions ppa,

372: BEGIN
373:
374: SELECT prt.run_type_name into l_run_type_name
375: FROM pay_run_types_f prt,
376: pay_payroll_actions ppa,
377: pay_assignment_actions paa
378: WHERE ppa.payroll_action_id = p_payroll_action_id
379: AND paa.payroll_action_id = ppa.payroll_action_id
380: AND prt.run_type_id = paa.run_type_id

Line 1341: FROM pay_payroll_actions ppa

1337: RETURN VARCHAR2
1338: IS
1339: CURSOR c_act_type IS
1340: SELECT 'L'
1341: FROM pay_payroll_actions ppa
1342: ,pay_assignment_actions paa
1343: WHERE paa.payroll_action_id = ppa.payroll_action_id
1344: AND paa.assignment_action_id = p_assignment_action_id
1345: AND EXISTS (SELECT 1

Line 1346: FROM pay_payroll_Actions ppa2

1342: ,pay_assignment_actions paa
1343: WHERE paa.payroll_action_id = ppa.payroll_action_id
1344: AND paa.assignment_action_id = p_assignment_action_id
1345: AND EXISTS (SELECT 1
1346: FROM pay_payroll_Actions ppa2
1347: WHERE ppa2.effective_date >= ppa.effective_date
1348: AND ppa2.action_type IN ('R','Q')
1349: AND ppa2.action_status = 'C') ;
1350:

Line 1351: l_act_type pay_payroll_actions.action_type%TYPE;

1347: WHERE ppa2.effective_date >= ppa.effective_date
1348: AND ppa2.action_type IN ('R','Q')
1349: AND ppa2.action_status = 'C') ;
1350:
1351: l_act_type pay_payroll_actions.action_type%TYPE;
1352: BEGIN
1353:
1354: OPEN c_act_type;
1355: FETCH c_act_type