APPS.PAY_CN_SOE dependencies on PAY_ACTION_INTERLOCKS

Line 32: FROM pay_action_interlocks

28:
29: CURSOR csr_prepayments_action_id
30: IS
31: SELECT locking_action_id
32: FROM pay_action_interlocks
33: WHERE locked_action_id = p_assignment_action_id;
34: BEGIN
35:
36: l_procedure := 'getelements';

Line 312: FROM pay_action_interlocks ai

308: , pay_org_payment_methods_f opm
309: , pay_payment_types_tl pt
310: WHERE pp.assignment_action_id IN
311: (SELECT ai.locking_action_id
312: FROM pay_action_interlocks ai
313: WHERE ai.locked_action_id :action_clause)
314: AND pp.personal_payment_method_id = ppm.personal_payment_method_id(+)
315: AND :effective_date BETWEEN ppm.effective_start_date(+)
316: AND ppm.effective_end_date(+)

Line 346: FROM pay_action_interlocks

342:
343: CURSOR csr_prepayment
344: IS
345: SELECT MAX(locked_action_id)
346: FROM pay_action_interlocks
347: WHERE locking_action_id = p_assignment_action_id;
348:
349: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
350:

Line 516: FROM pay_action_interlocks

512:
513: CURSOR csr_prepayment
514: IS
515: SELECT MAX(locked_action_id)
516: FROM pay_action_interlocks
517: WHERE locking_action_id = p_assignment_action_id;
518:
519: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
520: l_accrual_category pay_accrual_plans.accrual_category%TYPE;

Line 604: FROM pay_action_interlocks

600:
601: CURSOR csr_prepayment
602: IS
603: SELECT MAX(locked_action_id)
604: FROM pay_action_interlocks
605: WHERE locking_action_id = p_assignment_action_id;
606:
607: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
608:

Line 681: FROM pay_action_interlocks

677:
678: CURSOR csr_prepayment
679: IS
680: SELECT MAX(locked_action_id)
681: FROM pay_action_interlocks
682: WHERE locking_action_id = p_assignment_action_id;
683:
684: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
685: