APPS.POA_SUPPLIER_CONSOLIDATION_PK dependencies on FND_USER_RESP_GROUPS

Line 112: FROM fnd_user_resp_groups

108: OR ALL_SUPPLIER = p_cons_supplier_id)
109: AND (psp.org_id in (SELECT id FROM bis_operating_units_v
110: WHERE responsibility_id in
111: (SELECT responsibility_id
112: FROM fnd_user_resp_groups
113: WHERE user_id = p_user_id
114: AND sysdate BETWEEN start_date
115: AND NVL(end_date, sysdate+1)))
116: OR psp.org_id IS NULL)

Line 207: FROM fnd_user_resp_groups

203: AND phc2.vendor_id = p_pref_supplier_id
204: AND (phc2.org_id in (SELECT id FROM bis_operating_units_v
205: WHERE responsibility_id in
206: (SELECT responsibility_id
207: FROM fnd_user_resp_groups
208: WHERE user_id = p_user_id
209: AND sysdate BETWEEN start_date
210: AND NVL(end_date, sysdate+1)))
211: OR phc2.org_id IS NULL)

Line 285: FROM fnd_user_resp_groups

281: AND phc2.vendor_id = p_pref_supplier_id
282: AND (phc2.org_id in (SELECT id FROM bis_operating_units_v
283: WHERE responsibility_id in
284: (SELECT responsibility_id
285: FROM fnd_user_resp_groups
286: WHERE user_id = p_user_id
287: AND sysdate BETWEEN start_date
288: AND NVL(end_date, sysdate+1)))
289: OR phc2.org_id IS NULL)

Line 354: FROM fnd_user_resp_groups

350: AND psp.supplier_id = p_pref_supplier_id
351: AND (psp.org_id in (SELECT id FROM bis_operating_units_v
352: WHERE responsibility_id in
353: (SELECT responsibility_id
354: FROM fnd_user_resp_groups
355: WHERE user_id = p_user_id
356: AND sysdate BETWEEN start_date
357: AND NVL(end_date, sysdate+1)))
358: OR psp.org_id IS NULL);

Line 397: FROM fnd_user_resp_groups

393: AND psp.supplier_id = p_pref_supplier_id
394: AND (psp.org_id in (SELECT id FROM bis_operating_units_v
395: WHERE responsibility_id in
396: (SELECT responsibility_id
397: FROM fnd_user_resp_groups
398: WHERE user_id = p_user_id
399: AND sysdate BETWEEN start_date
400: AND NVL(end_date, sysdate+1)))
401: OR psp.org_id IS NULL);

Line 441: FROM fnd_user_resp_groups

437: AND psp.supplier_id = p_pref_supplier_id
438: AND (psp.org_id in (SELECT id FROM bis_operating_units_v
439: WHERE responsibility_id in
440: (SELECT responsibility_id
441: FROM fnd_user_resp_groups
442: WHERE user_id = p_user_id
443: AND sysdate BETWEEN start_date
444: AND NVL(end_date, sysdate+1)))
445: OR psp.org_id IS NULL);