DBA Data[Home] [Help]

APPS.ARRX_TX dependencies on AR_PAYMENT_SCHEDULES

Line 1307: AR_PAYMENT_SCHEDULES PS,'||

1303: --
1304: -- Add to the FROM clause specific to this report
1305: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1306: fa_rx_util_pkg.From_Clause := '
1307: AR_PAYMENT_SCHEDULES PS,'||
1308: fa_rx_util_pkg.From_Clause || ',
1309: AR_CONS_INV CONS_INV';
1310:
1311: --

Line 1856: FROM AR_PAYMENT_SCHEDULES PS, AR_CONS_INV CONS_INV

1852: return VARCHAR2
1853: is
1854: CURSOR CONS_BILL(CTID IN NUMBER) IS
1855: SELECT CONS_INV.CONS_BILLING_NUMBER
1856: FROM AR_PAYMENT_SCHEDULES PS, AR_CONS_INV CONS_INV
1857: WHERE PS.CONS_INV_ID = CONS_INV.CONS_INV_ID
1858: AND PS.STATUS = 'OP'
1859: AND PS.CUSTOMER_TRX_ID = CTID;
1860: