APPS.PV_USER_RESP_PVT dependencies on PV_PARTNER_PRIMARY_USERS_V

Line 139: FROM pv_partner_primary_users_v

135: i NUMBER := 1;
136:
137: CURSOR c_primary_user_ids IS
138: SELECT user_id
139: FROM pv_partner_primary_users_v
140: WHERE partner_id = p_partner_id;
141:
142: CURSOR c_business_user_ids IS
143: SELECT user_id

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,