257: l_party_id IN NUMBER,
258: l_party_site_id IN NUMBER)
259: IS
260: SELECT 'Y'
261: FROM hz_party_sites
262: WHERE party_id = l_party_id
263: AND party_site_id = l_party_site_id;
264:
265: CURSOR c_validate_partner_contact(
361: CURSOR c_validate_party_address(
362: l_party_site_id IN NUMBER )
363: IS
364: SELECT 'Y'
365: FROM hz_party_sites
366: WHERE party_site_id = l_party_site_id;
367:
368:
369: CURSOR c_validate_party_contact(
2405: l_party_id IN NUMBER,
2406: l_party_site_id IN NUMBER)
2407: IS
2408: SELECT 'Y'
2409: FROM hz_party_sites
2410: WHERE party_id = l_party_id
2411: AND party_site_id = l_party_site_id;
2412:
2413: CURSOR c_validate_partner_contact(
2506: CURSOR c_validate_party_address(
2507: l_party_site_id IN NUMBER )
2508: IS
2509: SELECT 'Y'
2510: FROM hz_party_sites
2511: WHERE party_site_id = l_party_site_id;
2512:
2513:
2514: CURSOR c_validate_party_contact(