DBA Data[Home] [Help]

APPS.FV_CCR_DATA_LOAD_PKG dependencies on FV_CCR_VENDORS_S

Line 3480: SELECT FV_CCR_VENDORS_S.nextval ,'Y','R',l_status,

3476: -- Added for bug 6339382
3477: ORGANIZATIONAL_TYPE
3478:
3479: )
3480: SELECT FV_CCR_VENDORS_S.nextval ,'Y','R',l_status,
3481: DUNS ,
3482: PLUS_FOUR ,
3483: CAGE_CODE ,
3484: EXTRACT_CODE ,

Line 4386: SELECT FV_CCR_VENDORS_S.nextval ,'Y','R',l_status,

4382: -- Added for bug 6339382
4383: ORGANIZATIONAL_TYPE
4384:
4385: )
4386: SELECT FV_CCR_VENDORS_S.nextval ,'Y','R',l_status,
4387: DUNS ,
4388: PLUS_FOUR ,
4389: CAGE_CODE ,
4390: EXTRACT_CODE ,

Line 4775: update fv_ccr_vendors set extract_code=decode(l_file_type,'M','A','2')

4771: END IF;
4772: END IF;
4773:
4774: -- made this change a part of bug 3872249
4775: update fv_ccr_vendors set extract_code=decode(l_file_type,'M','A','2')
4776: where duns in ( select distinct duns from fv_ccr_process_gt)
4777: and extract_code ='N'
4778: and plus_four is null;
4779: