DBA Data[Home] [Help]

APPS.FV_CCR_DATA_LOAD_PKG dependencies on FV_CCR_ORGS

Line 380: from fv_ccr_orgs o

376: SELECT * from fv_ccr_process_gt g
377: WHERE ( extract_code in ('A','2','3')
378: or ( l_run_from_xml = 'Y' and extract_code = '4' -- modified by ks 5906546.
379: and not exists (select 'first run'
380: from fv_ccr_orgs o
381: where o.duns = g.duns)
382: )
383: )
384: order by rowid;

Line 4785: and not exists (select 1 from fv_ccr_orgs fco

4781:
4782: -- made this change as part of BUG 3989083
4783: update fv_ccr_vendors fcv set fcv.enabled='Y'
4784: where fcv.enabled='N' and fcv.ccr_status='A'
4785: and not exists (select 1 from fv_ccr_orgs fco
4786: where fco.ccr_id = fcv.ccr_id);
4787: -- BUG 3989083
4788:
4789: IF (p_xml_import='Y' and p_insert_data='Y') THEN