APPS.PAY_IN_SOE_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 672: FROM pay_action_interlocks ai

668: , pay_org_payment_methods_f opm
669: , pay_payment_types_tl pt
670: WHERE pp.assignment_action_id IN
671: (SELECT ai.locking_action_id
672: FROM pay_action_interlocks ai
673: WHERE ai.locked_action_id :action_clause)
674: AND pp.personal_payment_method_id = ppm.personal_payment_method_id(+)
675: AND :effective_date BETWEEN ppm.effective_start_date(+)
676: AND ppm.effective_end_date(+)

Line 712: FROM pay_action_interlocks

708:
709: CURSOR csr_prepayment
710: IS
711: SELECT MAX(locked_action_id)
712: FROM pay_action_interlocks
713: WHERE locking_action_id = p_assignment_action_id;
714:
715: CURSOR csr_get_bg_id
716: IS

Line 895: FROM pay_action_interlocks

891:
892: CURSOR csr_prepayment
893: IS
894: SELECT MAX(locked_action_id)
895: FROM pay_action_interlocks
896: WHERE locking_action_id = p_assignment_action_id;
897:
898: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
899: l_accrual_category pay_accrual_plans.accrual_category%TYPE;

Line 997: FROM pay_action_interlocks

993:
994: CURSOR csr_prepayment
995: IS
996: SELECT MAX(locked_action_id)
997: FROM pay_action_interlocks
998: WHERE locking_action_id = p_assignment_action_id;
999:
1000: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1001: l_procedure VARCHAR2(50);

Line 1079: FROM pay_action_interlocks

1075:
1076: CURSOR csr_prepayment
1077: IS
1078: SELECT MAX(locked_action_id)
1079: FROM pay_action_interlocks
1080: WHERE locking_action_id = p_assignment_action_id;
1081:
1082: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1083: l_procedure VARCHAR2(50);