DBA Data[Home] [Help]

APPS.IGIRCBJP dependencies on AR_PAYMENT_SCHEDULES

Line 34: PaymentScheduleId ar_payment_schedules.payment_schedule_id%TYPE,

30: -- and the TrxNumber still holds the invoice that the CM applies to.
31: --
32: TYPE TrxType IS RECORD
33: (
34: PaymentScheduleId ar_payment_schedules.payment_schedule_id%TYPE,
35: CmPsIdFlag VARCHAR2(1),
36: TrxNumber ra_customer_trx.trx_number%TYPE
37: );
38: --

Line 427: FROM ar_payment_schedules ps,

423: l_FirstInstallmentCode,
424: l_currency_code,
425: l_AmountReconcile,
426: l_FirstInstallmentFlag
427: FROM ar_payment_schedules ps,
428: ra_terms t,
429: ra_terms_lines tl,
430: ra_terms_lines tl_first
431: WHERE ps.payment_schedule_id = p_ps_id

Line 1576: from ar_payment_schedules

1572:
1573: FUNCTION ExistsINPaymentSchedules ( fp_ps_id in number) return boolean IS
1574: cursor c_exist is
1575: select 'x'
1576: from ar_payment_schedules
1577: where payment_schedule_id = fp_ps_id
1578: ;
1579: BEGIN
1580: FOR l_exist IN C_exist LOOP