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 982: from pay_action_interlocks ai

978: , pay_org_payment_methods_f opm
979: , pay_payment_types_tl pt
980: where pp.assignment_action_id in
981: (select ai.locking_action_id
982: from pay_action_interlocks ai
983: where ai.locked_action_id :action_clause)
984: and pp.personal_payment_method_id = ppm.personal_payment_method_id(+)
985: and :effective_date
986: between ppm.effective_start_date(+) and ppm.effective_end_date(+)