DBA Data[Home] [Help]

APPS.POS_ANON_PKG dependencies on FND_RESPONSIBILITY

Line 99: FROM fnd_responsibility

95: l_hier_rec l_hier_cur%ROWTYPE;
96:
97: CURSOR l_resp_cur IS
98: SELECT responsibility_id, application_id
99: FROM fnd_responsibility
100: WHERE responsibility_key = 'POS_SUPPLIER_GUEST_USER'
101: AND application_id =
102: (SELECT application_id FROM fnd_application WHERE application_short_name = 'POS');
103:

Line 185: FROM FND_RESPONSIBILITY

181:
182: CURSOR l_resp_cur
183: IS
184: SELECT application_id, responsibility_id
185: FROM FND_RESPONSIBILITY
186: WHERE responsibility_key = p_responsibility_key
187: AND start_date < sysdate
188: AND (end_date IS NULL OR end_date > sysdate);
189:

Line 302: FROM FND_RESPONSIBILITY

298: END IF;
299:
300: SELECT application_id, responsibility_id
301: INTO x_application_id, x_responsibility_id
302: FROM FND_RESPONSIBILITY
303: WHERE responsibility_key = p_responsibility_key;
304:
305: END get_various_login_info;
306: