APPS.FV_CCR_UTIL_PVT dependencies on FV_CCR_ORGS

Line 974: from fv_ccr_vendors fcv, fv_ccr_orgs fco

970:
971: l_update_tin_prf := get_profile_option('FV_CCR_UPDATE_TIN');
972:
973: select count(*) into l_vendor_cnt
974: from fv_ccr_vendors fcv, fv_ccr_orgs fco
975: where fcv.ccr_id = fco.ccr_id
976: and fcv.DUNS <> p_duns and fcv.vendor_id = p_vendor_id
977: and (fco.pay_site_id is not null or fco.MAIN_ADDRESS_SITE_ID is not null);
978:

Line 1201: UPDATE fv_ccr_orgs

1197: || SQLERRM);
1198: insert_for_report(p_duns,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1199: if(l_new_bank_account_id IS NOT NULL AND
1200: l_new_bank_account_id<>0) THEN
1201: UPDATE fv_ccr_orgs
1202: SET bank_account_id = l_new_bank_account_id,
1203: last_update_date=sysdate,
1204: last_updated_by=l_user_id,
1205: last_update_login=l_login_id

Line 1759: UPDATE FV_CCR_ORGS

1755: l_assgn_conc_req_status:=p_assgn_conc_req_status;
1756: END IF;
1757:
1758:
1759: UPDATE FV_CCR_ORGS
1760: SET pay_site_id = l_pay_site_id,
1761: main_address_site_id = l_main_add_site_id,
1762: bank_account_id = l_new_bank_account_id,
1763: conc_request_status=l_assgn_conc_req_status,

Line 1936: UPDATE fv_ccr_orgs

1932: last_update_login=l_login_id
1933: WHERE ccr_id=p_ccr_id;
1934: END IF;
1935: IF(p_assgn_conc_req_status = 'S') THEN
1936: UPDATE fv_ccr_orgs
1937: SET conc_request_status=l_assgn_conc_req_status,
1938: last_update_date=sysdate,
1939: last_updated_by=l_user_id,
1940: last_update_login=l_login_id

Line 2025: delete from fv_ccr_orgs

2021: from fv_ccr_vendors
2022: where ccr_id = p_ccrid;
2023:
2024: if v_plus_four is null then
2025: delete from fv_ccr_orgs
2026: where ccr_id in (
2027: select ccr_id
2028: from fv_ccr_vendors
2029: where duns = (select duns from fv_ccr_vendors where ccr_id =

Line 2051: from fv_ccr_orgs o, hr_organization_units ou, ap_supplier_sites_all vs

2047:
2048: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');
2049: IF p_org_id is NOT NULL THEN
2050: for crec in (select pay_site_id
2051: from fv_ccr_orgs o, hr_organization_units ou, ap_supplier_sites_all vs
2052: where o.pay_site_id is not null
2053: and o.pay_site_id = vs.VENDOR_SITE_ID
2054: and vs.ORG_ID = ou.organization_id
2055: and ou.organization_id = nvl(p_org_id,ou.organization_id)

Line 2083: from fv_ccr_orgs o, hr_organization_units ou, po_vendor_sites_all vs

2079:
2080: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');
2081: IF p_org_id is NOT NULL THEN
2082: for crec in (select main_address_site_id
2083: from fv_ccr_orgs o, hr_organization_units ou, po_vendor_sites_all vs
2084: where o.main_address_site_id is not null
2085: and o.main_address_site_flag = 'Y'
2086: and o.main_address_site_id = vs.VENDOR_SITE_ID
2087: and vs.ORG_ID = ou.organization_id

Line 2161: FROM fv_ccr_orgs fco

2157: l_count := 0;
2158:
2159: SELECT COUNT(*)
2160: INTO l_count
2161: FROM fv_ccr_orgs fco
2162: WHERE fco.ccr_id = p_ccr_id
2163: AND mo_global.check_access(fco.org_id)<>'Y';
2164:
2165:

Line 3555: from fv_ccr_vendors fcv, fv_ccr_class_codes fcc, fv_ccr_orgs fco

3551: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_supplier_debarred';
3552: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3553:
3554: select fcc.code into l_debar_code
3555: from fv_ccr_vendors fcv, fv_ccr_class_codes fcc, fv_ccr_orgs fco
3556: where fcv.duns = fcc.duns(+)
3557: and fcv.ccr_id = fco.ccr_id(+)
3558: and fcv.vendor_id = p_supplier_id
3559: and fco.pay_site_id = p_supplier_site_id;