APPS.FV_CCR_DATA_LOAD_PKG dependencies on FV_CCR_PROCESS_REPORT

Line 34: INSERT INTO FV_CCR_PROCESS_REPORT

30: p_reference4 varchar2 ,
31: p_reference5 varchar2 )
32: IS
33: BEGIN
34: INSERT INTO FV_CCR_PROCESS_REPORT
35: (record_type,
36: duns_info,
37: reference1,
38: reference2,

Line 400: from fv_ccr_process_report order by record_type,rowid;

396: REFERENCE7,
397: REFERENCE8,
398: REFERENCE9,
399: REFERENCE10
400: from fv_ccr_process_report order by record_type,rowid;
401:
402:
403:
404: CURSOR c_taxpayer is

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

2669: AND nvl(fcv.plus_four,-99)= nvl(fcpg.plus_four,-99)
2670: AND fcpg.extract_code = '4');
2671:
2672: -- Fixed as part of BUG 3960809 for showing deleted/expired DUNS returned
2673: insert into fv_ccr_process_report(duns_info,record_type,reference1,reference2,reference3,reference4)
2674: SELECT DUNS||nvl(plus_four,''),'1',legal_bus_name,' ',' ',decode(fcpg.extract_code,'1','Deleted','4','Expired')
2675: FROM fv_ccr_process_gt fcpg
2676: WHERE fcpg.extract_code IN ('1','4');
2677:

Line 4896: delete from fv_ccr_process_report ;

4892:
4893: -- purge the temporary tables
4894: delete from fv_ccr_file_temp;
4895: delete from fv_ccr_process_gt;
4896: delete from fv_ccr_process_report ;
4897: commit;
4898:
4899: exception when others then
4900: l_errbuf := 'Exception occurred '||SQLERRM;