21: -- and the TrxNumber still holds the invoice that the CM applies to.
22: --
23: TYPE TrxType IS RECORD
24: (
25: PaymentScheduleId ar_payment_schedules.payment_schedule_id%TYPE,
26: CmPsIdFlag VARCHAR2(1),
27: Class ar_payment_schedules.class%TYPE,
28: TrxNumber ra_customer_trx.trx_number%TYPE,
29: OrgId ra_customer_trx.org_id%TYPE
23: TYPE TrxType IS RECORD
24: (
25: PaymentScheduleId ar_payment_schedules.payment_schedule_id%TYPE,
26: CmPsIdFlag VARCHAR2(1),
27: Class ar_payment_schedules.class%TYPE,
28: TrxNumber ra_customer_trx.trx_number%TYPE,
29: OrgId ra_customer_trx.org_id%TYPE
30: );
31: --
523: l_FirstInstallmentCode,
524: l_currency_code,
525: l_AmountReconcile,
526: l_FirstInstallmentFlag
527: FROM ar_payment_schedules ps,
528: ra_terms t,
529: ra_terms_lines tl,
530: ra_terms_lines tl_first
531: WHERE ps.payment_schedule_id = p_ps_id