DBA Data[Home] [Help]

APPS.FV_CCR_DATA_LOAD_PKG dependencies on FV_CCR_ORGS

Line 390: from fv_ccr_orgs o

386: SELECT * from fv_ccr_process_gt g
387: WHERE ( extract_code in ('A','2','3')
388: or ( l_run_from_xml = 'Y' and extract_code = '4' -- modified by ks 5906546.
389: and not exists (select 'first run'
390: from fv_ccr_orgs o
391: where o.duns = g.duns)
392: )
393: )
394: order by rowid;

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

4590:
4591: -- made this change as part of BUG 3989083
4592: update fv_ccr_vendors fcv set fcv.enabled='Y'
4593: where fcv.enabled='N' and fcv.ccr_status='A'
4594: and not exists (select 1 from fv_ccr_orgs fco
4595: where fco.ccr_id = fcv.ccr_id);
4596: -- BUG 3989083
4597:
4598: IF (p_xml_import='Y' and p_insert_data='Y') THEN