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 1356: FROM pay_payroll_actions ppa

1352: RETURN VARCHAR2
1353: IS
1354: CURSOR c_act_type IS
1355: SELECT 'L'
1356: FROM pay_payroll_actions ppa
1357: ,pay_assignment_actions paa
1358: WHERE paa.payroll_action_id = ppa.payroll_action_id
1359: AND paa.assignment_action_id = p_assignment_action_id
1360: AND EXISTS (SELECT 1

Line 1361: FROM pay_payroll_Actions ppa2

1357: ,pay_assignment_actions paa
1358: WHERE paa.payroll_action_id = ppa.payroll_action_id
1359: AND paa.assignment_action_id = p_assignment_action_id
1360: AND EXISTS (SELECT 1
1361: FROM pay_payroll_Actions ppa2
1362: WHERE ppa2.effective_date >= ppa.effective_date
1363: AND ppa2.action_type IN ('R','Q')
1364: AND ppa2.action_status = 'C') ;
1365:

Line 1366: l_act_type pay_payroll_actions.action_type%TYPE;

1362: WHERE ppa2.effective_date >= ppa.effective_date
1363: AND ppa2.action_type IN ('R','Q')
1364: AND ppa2.action_status = 'C') ;
1365:
1366: l_act_type pay_payroll_actions.action_type%TYPE;
1367: BEGIN
1368:
1369: OPEN c_act_type;
1370: FETCH c_act_type

Line 2757: select count(1) into l_payroll_actions from pay_payroll_actions

2753: end if ;
2754:
2755:
2756:
2757: select count(1) into l_payroll_actions from pay_payroll_actions
2758: where payroll_id=p_payroll_id
2759: and action_type in ('R', 'Q', 'B', 'V');
2760:
2761: if l_payroll_actions > 0 then