DBA Data[Home] [Help]

APPS.PAY_AE_CHEQUE_REPORT dependencies on PAY_PRE_PAYMENTS_V2

Line 163: FROM pay_pre_payments_v2 pv2

159: /* Cursor for fetching the Cheque details */
160:
161: CURSOR csr_chq_det (l_assact_id number,l_date date) IS
162: SELECT serial_number, value
163: FROM pay_pre_payments_v2 pv2
164: WHERE pv2.business_group_id+0 = p_business_group_id
165: AND pv2.assignment_action_id = l_assact_id
166: AND pv2.pre_payment_id in (select ppp.pre_payment_id
167: from pay_pre_payments ppp,pay_action_interlocks lck , pay_org_payment_methods_f org ,