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 2126: FROM HZ_PARTY_SITES a

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

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

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

Line 7318: HZ_PARTY_SITES site

7314: SELECT 1 FROM DUAL WHERE EXISTS
7315: (
7316: SELECT site.party_site_id
7317: FROM HZ_PARTIES hp,
7318: HZ_PARTY_SITES site
7319: WHERE site.party_id = hp.party_id
7320: AND site.PARTY_SITE_ID = p_party_site_id --Added join for party_site_id
7321: AND hp.status = 'A'
7322: AND site.status = 'A'

Line 7332: HZ_PARTY_SITES site

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

Line 7347: HZ_PARTY_SITES site

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