DBA Data[Home] [Help]

APPS.PAY_SOE_GLB dependencies on PAY_ACTION_INTERLOCKS

Line 55: from pay_action_interlocks,

51:
52: cursor lockedActions is
53: select locked_action_id,
54: action_sequence
55: from pay_action_interlocks,
56: pay_assignment_actions
57: where locking_action_id = p_assignment_action_id
58: and locked_action_id = assignment_action_id
59: order by action_sequence desc;

Line 907: from pay_action_interlocks ai

903: , pay_org_payment_methods_f opm
904: , pay_payment_types_tl pt
905: where pp.assignment_action_id in
906: (select ai.locking_action_id
907: from pay_action_interlocks ai
908: where ai.locked_action_id :action_clause)
909: and pp.personal_payment_method_id = ppm.personal_payment_method_id(+)
910: and :effective_date
911: between ppm.effective_start_date(+) and ppm.effective_end_date(+)