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 341: FROM pay_action_interlocks ai

337: , pay_org_payment_methods_f opm
338: , pay_payment_types_tl pt
339: WHERE pp.assignment_action_id IN
340: (SELECT ai.locking_action_id
341: FROM pay_action_interlocks ai
342: WHERE ai.locked_action_id :action_clause)
343: AND pp.personal_payment_method_id = ppm.personal_payment_method_id(+)
344: AND :effective_date BETWEEN ppm.effective_start_date(+)
345: AND ppm.effective_end_date(+)

Line 375: FROM pay_action_interlocks

371:
372: CURSOR csr_prepayment
373: IS
374: SELECT MAX(locked_action_id)
375: FROM pay_action_interlocks
376: WHERE locking_action_id = p_assignment_action_id;
377:
378: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
379:

Line 578: FROM pay_action_interlocks

574:
575: CURSOR csr_prepayment
576: IS
577: SELECT MAX(locked_action_id)
578: FROM pay_action_interlocks
579: WHERE locking_action_id = p_assignment_action_id;
580:
581: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
582: l_accrual_category pay_accrual_plans.accrual_category%TYPE;

Line 687: FROM pay_action_interlocks

683:
684: CURSOR csr_prepayment
685: IS
686: SELECT MAX(locked_action_id)
687: FROM pay_action_interlocks
688: WHERE locking_action_id = p_assignment_action_id;
689:
690: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
691:

Line 765: FROM pay_action_interlocks

761:
762: CURSOR csr_prepayment
763: IS
764: SELECT MAX(locked_action_id)
765: FROM pay_action_interlocks
766: WHERE locking_action_id = p_assignment_action_id;
767:
768: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
769: