DBA Data[Home] [Help]

APPS.PAY_AE_CHEQUE_REPORT dependencies on PAY_PRE_PAYMENTS_V2

Line 179: FROM pay_pre_payments_v2 pv2

175: /* Cursor for fetching the Cheque details */
176:
177: CURSOR csr_chq_det (l_assact_id number,l_date date) IS
178: SELECT serial_number, value
179: FROM pay_pre_payments_v2 pv2
180: WHERE pv2.business_group_id+0 = p_business_group_id
181: AND pv2.assignment_action_id = l_assact_id
182: AND pv2.pre_payment_id in (select ppp.pre_payment_id
183: from pay_pre_payments ppp,pay_action_interlocks lck , pay_org_payment_methods_f org ,