APPS.FII_SIZING_UTIL dependencies on PA_CUST_REV_DIST_LINES_ALL

Line 9: FROM pa_cust_rev_dist_lines_all

5: p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER) IS
6: cursor c_cnt_rows is
7: select SUM(cnt) from
8: (select count(*) cnt
9: FROM pa_cust_rev_dist_lines_all
10: WHERE program_update_date BETWEEN p_from_date and p_to_date
11: and function_code NOT IN ('LRL','LRB','URL','URB')
12: UNION ALL
13: select count(*) cnt

Line 356: pa_cust_rev_dist_lines_all rdl

352: AND jeh.actual_flag = 'A'
353: UNION ALL
354: SELECT count(*)
355: FROM
356: pa_cust_rev_dist_lines_all rdl
357: WHERE rdl.creation_date between p_from_date and p_to_date
358: AND rdl.function_code NOT IN ('LRL', 'LRB', 'URL', 'URB')
359: UNION ALL
360: SELECT count(*)