APPS.FV_CCR_UTIL_PVT dependencies on HZ_PARTY_SITES

Line 226: FROM ap_supplier_sites_all pavs, hz_party_sites hps

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

Line 1332: UPDATE hz_party_sites

1328: -- Added for bug 6238518
1329: IF (l_status = 'S') THEN
1330: IF NVL(p_main_address_flag,'N') = 'Y' THEN
1331: fv_utility.log_mesg('Updating mail poc for main site id:'||l_party_site_id);
1332: UPDATE hz_party_sites
1333: SET addressee = p_mail_poc
1334: WHERE party_site_id = l_party_site_id;
1335: END IF;
1336: END IF;

Line 1382: UPDATE hz_party_sites

1378: -- Added for bug 6238518
1379: IF (l_status = 'S') THEN
1380: IF NVL(p_main_address_flag,'N') = 'Y' THEN
1381: fv_utility.log_mesg('Updating mail poc for main site id: '||l_party_site_id);
1382: UPDATE hz_party_sites
1383: SET addressee = p_mail_poc
1384: WHERE party_site_id = l_party_site_id;
1385: END IF;
1386: END IF;

Line 1587: UPDATE hz_party_sites

1583: -- Added for bug 6238518
1584: IF (l_status = 'S') THEN
1585: IF NVL(l_pay_site_flag,'N') = 'Y' THEN
1586: fv_utility.log_mesg('Updating remit poc for site id: '||l_party_site_id);
1587: UPDATE hz_party_sites
1588: SET addressee = p_remit_poc
1589: WHERE party_site_id = l_party_site_id;
1590: END IF;
1591: END IF;

Line 1671: UPDATE hz_party_sites

1667:
1668: -- Added for bug 6238518
1669: IF (l_status = 'S') THEN
1670: fv_utility.log_mesg('Updating remit poc for site id: '||l_party_site_id);
1671: UPDATE hz_party_sites
1672: SET addressee = p_remit_poc
1673: WHERE party_site_id = l_party_site_id;
1674: END IF;
1675:

Line 2651: from hz_party_sites

2647: l_party_site_rec.party_site_id := l_party_site_id;
2648:
2649: select object_version_number
2650: into l_object_version_number
2651: from hz_party_sites
2652: where party_site_id = l_party_site_id;
2653:
2654:
2655: hz_party_site_v2pub.update_party_site(