APPS.FII_AR_FACTS_AGING_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 917: RA_CUSTOMER_TRX_ALL trx,

913: sysdate, --LAST_UPDATE_DATE,
914: g_fii_user_id, --LAST_UPDATED_BY,
915: g_fii_login_id --LAST_UPDATE_LOGIN
916: FROM AR_PAYMENT_SCHEDULES_ALL sch,
917: RA_CUSTOMER_TRX_ALL trx,
918: FII_AR_CURR_RATES_T rt,
919: AR_SYSTEM_PARAMETERS_ALL par,
920: GL_SETS_OF_BOOKS sob,
921: AR_TRANSACTION_HISTORY_ALL h,

Line 1375: FROM ra_customer_trx_all trx,

1371: g_fii_user_id, --CREATED_BY,
1372: sysdate, --LAST_UPDATE_DATE,
1373: g_fii_user_id, --LAST_UPDATED_BY,
1374: g_fii_login_id --LAST_UPDATE_LOGIN
1375: FROM ra_customer_trx_all trx,
1376: FII_AR_PMT_SCHEDULES_F sch
1377: WHERE trx.customer_trx_id = sch.customer_trx_id
1378: AND sch.class <> 'PMT'
1379: AND decode(g_collection_criteria,

Line 4595: from ra_customer_trx_all

4591: (
4592: customer_trx_id
4593: )
4594: select CUSTOMER_TRX_ID
4595: from ra_customer_trx_all
4596: where LAST_UPDATE_DATE > G_LAST_UPDATE_DATE
4597: and COMPLETE_FLAG = 'N'
4598: and last_update_date <= g_sysdate_time
4599: ;

Line 5044: RA_CUSTOMER_TRX_ALL trx,

5040: sysdate LAST_UPDATE_DATE,
5041: g_fii_user_id LAST_UPDATED_BY,
5042: g_fii_login_id LAST_UPDATE_LOGIN
5043: FROM FII_AR_PAYSCH_MERGE_GT sch,
5044: RA_CUSTOMER_TRX_ALL trx,
5045: FII_AR_CURR_RATES_T rt,
5046: AR_SYSTEM_PARAMETERS_ALL par,
5047: GL_SETS_OF_BOOKS sob
5048: WHERE sch.class IN ('INV','DM','CB','CM','DEP','BR', 'PMT')

Line 5583: select * from ra_customer_trx_all

5579: sysdate LAST_UPDATE_DATE,
5580: g_fii_user_id LAST_UPDATED_BY,
5581: g_fii_login_id LAST_UPDATE_LOGIN
5582: FROM (
5583: select * from ra_customer_trx_all
5584: where CUSTOMER_TRX_ID in (
5585: -- Trans Insert, Update
5586: select CUSTOMER_TRX_ID
5587: from FII_AR_PAYSCH_INSERT_GT