APPS.FV_CCR_DATA_LOAD_PKG dependencies on FV_CCR_PROCESS_REPORT

Line 42: INSERT INTO FV_CCR_PROCESS_REPORT

38: p_reference4 varchar2 ,
39: p_reference5 varchar2 )
40: IS
41: BEGIN
42: INSERT INTO FV_CCR_PROCESS_REPORT
43: (record_type,
44: duns_info,
45: reference1,
46: reference2,

Line 410: from fv_ccr_process_report order by record_type,rowid;

406: REFERENCE7,
407: REFERENCE8,
408: REFERENCE9,
409: REFERENCE10
410: from fv_ccr_process_report order by record_type,rowid;
411:
412:
413:
414: CURSOR c_taxpayer is

Line 2614: insert into fv_ccr_process_report(duns_info,record_type,reference1,reference2,reference3,reference4)

2610: AND nvl(fcv.plus_four,-99)= nvl(fcpg.plus_four,-99)
2611: AND fcpg.extract_code = '4');
2612:
2613: -- Fixed as part of BUG 3960809 for showing deleted/expired DUNS returned
2614: insert into fv_ccr_process_report(duns_info,record_type,reference1,reference2,reference3,reference4)
2615: SELECT DUNS||nvl(plus_four,''),'1',legal_bus_name,' ',' ',decode(fcpg.extract_code,'1','Deleted','4','Expired')
2616: FROM fv_ccr_process_gt fcpg
2617: WHERE fcpg.extract_code IN ('1','4');
2618:

Line 4726: delete from fv_ccr_process_report ;

4722:
4723: -- purge the temporary tables
4724: delete from fv_ccr_file_temp;
4725: delete from fv_ccr_process_gt;
4726: delete from fv_ccr_process_report ;
4727: commit;
4728:
4729: exception
4730: when others then