APPS.HZ_CUSTOMER_PROFILE_V2PUB dependencies on HZ_PARTIES

Line 117: hz_parties b

113: IS
114: CURSOR c1 IS
115: SELECT a.party_id
116: FROM hz_cust_accounts a,
117: hz_parties b
118: WHERE a.cust_account_id = p_cust_account_id
119: AND a.party_id = b.party_id
120: AND b.status = DECODE(p_active,'ALL',b.status,p_active);
121: l_party_id NUMBER;

Line 139: FROM hz_parties

135: RETURN VARCHAR2
136: IS
137: CURSOR c1 IS
138: SELECT 'Y'
139: FROM hz_parties
140: WHERE party_id = p_party_id
141: AND status = DECODE(p_active,'ALL',status,p_active);
142: lact VARCHAR2(1);
143: ret VARCHAR2(1);