APPS.ASO_VALIDATE_PVT dependencies on HZ_PARTY_SITES

Line 270: FROM HZ_PARTY_SITES

266: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
267: IS
268: CURSOR C_Party_Site IS
269: SELECT status -- start_date_active, end_date_active obsolete
270: FROM HZ_PARTY_SITES
271: WHERE party_site_id = p_party_site_id;
272:
273: l_status VARCHAR2(1);
274:

Line 2128: FROM HZ_PARTY_SITES a

2124: IS
2125:
2126: CURSOR C_Inv_Party_Site(l_pty_site NUMBER) IS
2127: SELECT a.status
2128: FROM HZ_PARTY_SITES a
2129: WHERE a.party_site_id = l_pty_site;
2130:
2131: l_status VARCHAR2(1);
2132:

Line 2546: SELECT b.party_id,a.party_type FROM HZ_PARTIES a,HZ_PARTY_SITES b

2542: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2543: IS
2544:
2545: CURSOR c_party_site( l_party_site_id NUMBER) IS
2546: SELECT b.party_id,a.party_type FROM HZ_PARTIES a,HZ_PARTY_SITES b
2547: WHERE a.party_id = b.party_id
2548: AND b.party_site_id = l_party_site_id;
2549:
2550: CURSOR C_Cust_party_id(l_cust_acct_id number) IS

Line 7334: HZ_PARTY_SITES site

7330: SELECT 1 FROM DUAL WHERE EXISTS
7331: (
7332: SELECT site.party_site_id
7333: FROM HZ_PARTIES hp,
7334: HZ_PARTY_SITES site
7335: WHERE site.party_id = hp.party_id
7336: AND site.PARTY_SITE_ID = p_party_site_id --Added join for party_site_id
7337: AND hp.status = 'A'
7338: AND site.status = 'A'

Line 7348: HZ_PARTY_SITES site

7344: SELECT 1 FROM DUAL WHERE EXISTS
7345: (
7346: SELECT site.party_site_id
7347: FROM HZ_PARTIES hp,
7348: HZ_PARTY_SITES site
7349: WHERE site.party_id = hp.party_id
7350: AND site.PARTY_SITE_ID = p_party_site_id --Added join for party_site_id
7351: AND hp.status = 'A'
7352: AND site.status = 'A'

Line 7363: HZ_PARTY_SITES site

7359: (
7360:
7361: SELECT site.party_site_id
7362: FROM HZ_PARTIES hp,
7363: HZ_PARTY_SITES site
7364: WHERE site.party_id = hp.party_id
7365: AND site.PARTY_SITE_ID = p_party_site_id --Added join for party_site_id
7366: AND hp.status = 'A'
7367: AND site.status = 'A'