APPS.FV_CCR_UTIL_PVT dependencies on HZ_PARTY_SITES

Line 223: FROM ap_supplier_sites_all pavs, hz_party_sites hps

219: --WHERE vendor_id=p_supp_id
220: --AND vendor_site_code=p_site_name
221: --AND org_id=p_org;
222: SELECT pavs.vendor_site_id, hps.duns_number_c
223: FROM ap_supplier_sites_all pavs, hz_party_sites hps
224: WHERE pavs.vendor_id = p_supp_id
225: AND pavs.vendor_site_code = p_site_name
226: AND pavs.org_id = p_org
227: AND pavs.party_site_id = hps.party_site_id;

Line 1253: UPDATE hz_party_sites

1249: -- Added for bug 6238518
1250: IF (l_status = 'S') THEN
1251: IF NVL(p_main_address_flag,'N') = 'Y' THEN
1252: fv_utility.log_mesg('Updating mail poc for main site id:'||l_party_site_id);
1253: UPDATE hz_party_sites
1254: SET addressee = p_mail_poc
1255: WHERE party_site_id = l_party_site_id;
1256: END IF;
1257: END IF;

Line 1303: UPDATE hz_party_sites

1299: -- Added for bug 6238518
1300: IF (l_status = 'S') THEN
1301: IF NVL(p_main_address_flag,'N') = 'Y' THEN
1302: fv_utility.log_mesg('Updating mail poc for main site id: '||l_party_site_id);
1303: UPDATE hz_party_sites
1304: SET addressee = p_mail_poc
1305: WHERE party_site_id = l_party_site_id;
1306: END IF;
1307: END IF;

Line 1417: UPDATE hz_party_sites

1413: -- Added for bug 6238518
1414: IF (l_status = 'S') THEN
1415: IF NVL(l_pay_site_flag,'N') = 'Y' THEN
1416: fv_utility.log_mesg('Updating remit poc for site id: '||l_party_site_id);
1417: UPDATE hz_party_sites
1418: SET addressee = p_remit_poc
1419: WHERE party_site_id = l_party_site_id;
1420: END IF;
1421: END IF;

Line 1501: UPDATE hz_party_sites

1497:
1498: -- Added for bug 6238518
1499: IF (l_status = 'S') THEN
1500: fv_utility.log_mesg('Updating remit poc for site id: '||l_party_site_id);
1501: UPDATE hz_party_sites
1502: SET addressee = p_remit_poc
1503: WHERE party_site_id = l_party_site_id;
1504: END IF;
1505:

Line 2373: from hz_party_sites

2369: l_party_site_rec.party_site_id := l_party_site_id;
2370:
2371: select object_version_number
2372: into l_object_version_number
2373: from hz_party_sites
2374: where party_site_id = l_party_site_id;
2375:
2376:
2377: hz_party_site_v2pub.update_party_site(