DBA Data[Home] [Help]

APPS.ARRX_TX dependencies on AR_PAYMENT_SCHEDULES

Line 1325: AR_PAYMENT_SCHEDULES PS,'||

1321: --
1322: -- Add to the FROM clause specific to this report
1323: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1324: fa_rx_util_pkg.From_Clause := '
1325: AR_PAYMENT_SCHEDULES PS,'||
1326: fa_rx_util_pkg.From_Clause || ',
1327: AR_CONS_INV CONS_INV';
1328:
1329: --

Line 1874: FROM AR_PAYMENT_SCHEDULES PS, AR_CONS_INV CONS_INV

1870: return VARCHAR2
1871: is
1872: CURSOR CONS_BILL(CTID IN NUMBER) IS
1873: SELECT CONS_INV.CONS_BILLING_NUMBER
1874: FROM AR_PAYMENT_SCHEDULES PS, AR_CONS_INV CONS_INV
1875: WHERE PS.CONS_INV_ID = CONS_INV.CONS_INV_ID
1876: AND PS.STATUS = 'OP'
1877: AND PS.CUSTOMER_TRX_ID = CTID;
1878: