APPS.PV_USER_RESP_PVT dependencies on PV_PARTNER_BUSINESS_USERS_V

Line 144: FROM pv_partner_business_users_v

140: WHERE partner_id = p_partner_id;
141:
142: CURSOR c_business_user_ids IS
143: SELECT user_id
144: FROM pv_partner_business_users_v
145: WHERE partner_id = p_partner_id;
146:
147: BEGIN
148: IF (PV_DEBUG_HIGH_ON) THEN

Line 216: * instead of using views pv_partner_primary_users_v and pv_partner_business_users_v

212: /*
213: * get_partner_users_2
214: * get the list of partner users based on the partner id and partner type
215: * differencies between get_partner_users and get_partner_users_2 is:
216: * instead of using views pv_partner_primary_users_v and pv_partner_business_users_v
217: * hardcoded the query of the views but took out the where status = 'A'
218: */
219: FUNCTION get_partner_users_2 (
220: p_partner_id IN NUMBER,

Line 7087: FROM pv_partner_business_users_v

7083: SELECT 1
7084: FROM dual
7085: WHERE EXISTS (
7086: SELECT 1
7087: FROM pv_partner_business_users_v
7088: WHERE partner_id = p_from_partner_id);
7089:
7090: CURSOR c_is_business_resp_exist IS
7091: SELECT 1