DBA Data[Home] [Help]

APPS.PAY_SA_CHEQUE_REPORT dependencies on PAY_PRE_PAYMENTS_V2

Line 168: FROM pay_pre_payments_v2 pv2

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