643: SELECT
644: count(*)
645: INTO L_TOTAL_SCHEDULED
646: FROM
647: AP_PAYMENT_SCHEDULES PAY,
648: AP_INVOICES INV
649: WHERE PAY.INVOICE_ID = INV.INVOICE_ID
650: AND TRUNC(INV.CREATION_DATE) <= TO_DATE(C_END_DATE
651: ,'DD/MM/YYYY');
1138: SELECT
1139: count(*)
1140: INTO L_PAYMENT_SCHEDULES
1141: FROM
1142: AP_PAYMENT_SCHEDULES PAY,
1143: AP_INVOICES INV
1144: WHERE PAY.INVOICE_ID = INV.INVOICE_ID
1145: AND TRUNC(INV.CREATION_DATE) >= TO_DATE(C_START_DATE
1146: ,'DD/MM/YYYY')