APPS.POS_REG_WF_PKG dependencies on FND_RESPONSIBILITY

Line 158: fnd_responsibility fr,

154:
155: OPEN x_refcur FOR
156: 'SELECT DISTINCT fu.user_name
157: FROM fnd_user fu,
158: fnd_responsibility fr,
159: wf_user_roles wur
160: WHERE fr.menu_id in
161: (SELECT fme.menu_id
162: FROM fnd_menu_entries fme

Line 2145: FROM fnd_responsibility

2141: ln_resp_id NUMBER := NULL;
2142:
2143: CURSOR l_resp_id_cur (p_app_id NUMBER, p_resp_key VARCHAR2) IS
2144: SELECT responsibility_id
2145: FROM fnd_responsibility
2146: WHERE application_id = p_app_id
2147: AND responsibility_key = p_resp_key
2148: AND (end_date IS NULL OR end_date > start_date);
2149:

Line 2604: FROM fnd_responsibility

2600: ln_resp_id NUMBER;
2601: --
2602: CURSOR l_resp_id_cur (p_appl_id NUMBER, p_resp_key VARCHAR2) IS
2603: SELECT responsibility_id
2604: FROM fnd_responsibility
2605: WHERE application_id = p_appl_id
2606: AND responsibility_key = p_resp_key
2607: AND (end_date IS NULL OR end_date > start_date);
2608: BEGIN

Line 2688: lv_resp_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE := NULL;

2684: ln_pos_app_id NUMBER := -1;
2685: lv_is_pos_selected VARCHAR2(1) := 'N';
2686: lv_is_pon_selected VARCHAR2(1) := 'N';
2687: lv_is_msc_selected VARCHAR2(1) := 'N';
2688: lv_resp_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE := NULL;
2689: ln_site_id NUMBER := -1;
2690: ln_contact_id NUMBER := -1;
2691: ln_resp_code VARCHAR2(240);
2692: ln_resp_id NUMBER := -1;