eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PURGE_BILLING dependencies on PA_CUST_RDL_AR

Line 127: PA_CUST_RDL_AR ar

123: mc.PROJFUNC_INV_RATE_TYPE,
124: mc.PROJFUNC_INV_RATE_DATE,
125: mc.PROJFUNC_INV_EXCHANGE_RATE
126: from Pa_Mc_Cust_Rdl_All mc,
127: PA_CUST_RDL_AR ar
128: where ar.purge_project_id = p_project_id
129: and mc.expenditure_item_id = ar.expenditure_item_id
130: and mc.line_num = ar.line_num;
131:

Line 233: insert into PA_CUST_RDL_AR

229: pa_debug.debug( ' ->Before insert into PA_Revenue_Distribution_Lines_AR') ;
230: IF l_crdl_rowid_tab.LAST is not null THEN
231: IF p_archive_flag = 'Y' THEN
232: FORALL l_crdl_ind in l_crdl_rowid_tab.FIRST .. l_crdl_rowid_tab.LAST
233: insert into PA_CUST_RDL_AR
234: (
235: PURGE_BATCH_ID,
236: PURGE_RELEASE,
237: PURGE_PROJECT_ID,

Line 447: PA_CUST_RDL_AR crdl2

443: delete from pa_cust_rev_dist_lines_all crdl
444: where (crdl.rowid) in
445: ( select crdl1.rowid
446: from pa_cust_rev_dist_lines_all crdl1,
447: PA_CUST_RDL_AR crdl2
448: where crdl2.expenditure_item_id = crdl1.expenditure_item_id
449: and crdl2.line_num = crdl1.line_num
450: and crdl2.purge_project_id = p_project_id
451: ) ;

Line 457: from PA_CUST_RDL_AR crdl2

453:
454: /* delete from pa_cust_rev_dist_lines_all crdl
455: where (crdl.expenditure_item_id, crdl.line_num) in
456: ( select crdl2.expenditure_item_id, crdl2.line_num
457: from PA_CUST_RDL_AR crdl2
458: where crdl2.purge_project_id = p_project_id
459: ) ;
460:
461: