DBA Data[Home] [Help]

APPS.PAY_IE_SOE dependencies on PAY_ACTION_INTERLOCKS

Line 254: select aa.assignment_action_id from pay_assignment_actions aa,pay_action_interlocks pai

250:
251: function Tax_PRSI_Info(p_assignment_action_id NUMBER) return long is
252:
253: Cursor c_pay_run(a_asg_action_id number) is
254: select aa.assignment_action_id from pay_assignment_actions aa,pay_action_interlocks pai
255: where locking_action_id=a_asg_action_id
256: and aa.assignment_action_id=locked_action_id
257: and aa.source_action_id is not null
258: and aa.action_status = 'C';