APPS.FII_SIZING_UTIL dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 210: ra_cust_trx_line_gl_dist_all ctlgd,

206: CURSOR c_cnt_rows IS
207: select sum(cnt) from
208: (SELECT count(*) cnt
209: FROM
210: ra_cust_trx_line_gl_dist_all ctlgd,
211: ra_customer_trx_lines_all ctl,
212: ra_customer_trx_all ct
213: WHERE ctlgd.account_set_flag = 'N'
214: AND ctlgd.last_update_date between p_from_date and p_to_date

Line 248: ra_cust_trx_line_gl_dist_all ctlgd,

244: AND ct.complete_flag = 'Y'
245: UNION ALL
246: SELECT count(*)
247: from
248: ra_cust_trx_line_gl_dist_all ctlgd,
249: ra_customer_trx_lines_all ctl,
250: ra_customer_trx_all ct
251: WHERE ctlgd.last_update_date between p_from_date and p_to_date
252: AND ctlgd.account_set_flag = 'N'

Line 273: ra_cust_trx_line_gl_dist_all ctlgd,

269: AND ct.complete_flag = 'Y'
270: UNION ALL
271: SELECT count(*)
272: FROM
273: ra_cust_trx_line_gl_dist_all ctlgd,
274: ra_customer_trx_lines_all ctl,
275: ra_customer_trx_all ct
276: WHERE ctlgd.last_update_date between p_from_date and p_to_date
277: AND ctlgd.account_set_flag = 'N'

Line 305: ra_cust_trx_line_gl_dist_all ctlgd,

301: CURSOR c_cnt_rows IS
302: select sum(cnt) from
303: (SELECT count(*) cnt
304: FROM
305: ra_cust_trx_line_gl_dist_all ctlgd,
306: ra_customer_trx_lines_all ctl,
307: ra_customer_trx_all ct
308: WHERE ctlgd.last_update_date between p_from_date and p_to_date
309: AND ctlgd.account_class not in ('REC','UNBILL')

Line 374: ra_cust_trx_line_gl_dist_all ctlgd,

370: AND pdr.released_date IS NOT NULL
371: UNION ALL
372: SELECT count(*)
373: from
374: ra_cust_trx_line_gl_dist_all ctlgd,
375: ra_customer_trx_lines_all ctl,
376: ra_customer_trx_all ct
377: WHERE ctlgd.last_update_date between p_from_date and p_to_date
378: AND ctlgd.account_class not in ('REC','UNBILL')