DBA Data[Home] [Help]

APPS.PAY_KW_CHEQUE_REPORT dependencies on PAY_PRE_PAYMENTS_V2

Line 197: FROM pay_pre_payments_v2 pv2

193:
194: /* Cursor for fetching the Cheque details */
195: CURSOR csr_chq_det (l_assact_id number,l_date date) IS
196: SELECT serial_number, value
197: FROM pay_pre_payments_v2 pv2
198: WHERE pv2.business_group_id+0 = p_business_group_id
199: AND pv2.assignment_action_id = l_assact_id
200: AND pv2.pre_payment_id in (select ppp.pre_payment_id
201: from pay_pre_payments ppp,pay_action_interlocks lck , pay_org_payment_methods_f org ,