DBA Data[Home] [Help]

APPS.IGIRCBAP dependencies on AR_PAYMENT_SCHEDULES

Line 37: PaymentScheduleId ar_payment_schedules.payment_schedule_id%TYPE,

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: );

Line 39: Class ar_payment_schedules.class%TYPE,

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

Line 436: FROM ar_payment_schedules ps,

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

Line 1431: from ar_payment_schedules

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