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 898: FROM pay_action_interlocks

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

Line 1017: FROM pay_action_interlocks

1013:
1014: CURSOR csr_prepayment
1015: IS
1016: SELECT MAX(locked_action_id)
1017: FROM pay_action_interlocks
1018: WHERE locking_action_id = p_assignment_action_id;
1019:
1020: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1021: l_procedure VARCHAR2(50);

Line 1099: FROM pay_action_interlocks

1095:
1096: CURSOR csr_prepayment
1097: IS
1098: SELECT MAX(locked_action_id)
1099: FROM pay_action_interlocks
1100: WHERE locking_action_id = p_assignment_action_id;
1101:
1102: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1103: l_procedure VARCHAR2(50);