DBA Data[Home] [Help]

APPS.PAY_US_TAXBAL_VIEW_PKG dependencies on PAY_PRE_PAYMENTS

Line 307: from pay_pre_payments ppp

303:
304: cursor c_payments (cp_pre_pymt_action_id number,
305: cp_assignment_action_id number) is
306: select ppp.source_action_id
307: from pay_pre_payments ppp
308: where ppp.assignment_action_id = cp_pre_pymt_action_id
309: and ppp.source_action_id = cp_assignment_action_id;
310: /*
311: CURSOR c_count_runs(cp_pre_pymt_action_id NUMBER ) IS

Line 314: pay_pre_payments ppp,

310: /*
311: CURSOR c_count_runs(cp_pre_pymt_action_id NUMBER ) IS
312: select count(pai.locked_action_id)
313: from pay_action_interlocks pai,
314: pay_pre_payments ppp,
315: pay_assignment_actions paa
316: where ppp.assignment_action_id = cp_pre_pymt_action_id
317: and nvl(ppp.source_action_id,0) <> pai.locked_action_id
318: and pai.locking_action_id = ppp.assignment_action_id