33: -- and the TrxNumber still holds the invoice that the CM applies to.
34: --
35: TYPE TrxType IS RECORD
36: (
37: PaymentScheduleId ar_payment_schedules.payment_schedule_id%TYPE,
38: CmPsIdFlag VARCHAR2(1),
39: Class ar_payment_schedules.class%TYPE,
40: TrxNumber ra_customer_trx.trx_number%TYPE
41: );
35: TYPE TrxType IS RECORD
36: (
37: PaymentScheduleId ar_payment_schedules.payment_schedule_id%TYPE,
38: CmPsIdFlag VARCHAR2(1),
39: Class ar_payment_schedules.class%TYPE,
40: TrxNumber ra_customer_trx.trx_number%TYPE
41: );
42: --
43: -- RECORD holder for pertinent information from a receivable application
432: l_FirstInstallmentCode,
433: l_currency_code,
434: l_AmountReconcile,
435: l_FirstInstallmentFlag
436: FROM ar_payment_schedules ps,
437: ra_terms t,
438: ra_terms_lines tl,
439: ra_terms_lines tl_first
440: WHERE ps.payment_schedule_id = p_ps_id
1427:
1428: FUNCTION ExistsINPaymentSchedules ( fp_ps_id in number) return boolean IS
1429: cursor c_exist is
1430: select 'x'
1431: from ar_payment_schedules
1432: where payment_schedule_id = fp_ps_id
1433: ;
1434: BEGIN
1435: FOR l_exist IN C_exist LOOP