21: from fnd_application
22: where application_short_name = upper(P_APPLICATION_SHORT_NAME);
23: CURSOR C_RESP IS
24: select responsibility_id
25: from fnd_responsibility_vl
26: where responsibility_name = P_RESPONSIBILITY_NAME
27: and application_id = l_appl_id;
28:
29: CURSOR C1 (c1_p_appl_id number, c1_p_resp_id number) IS
71: from fnd_application
72: where application_short_name = upper(P_APPLICATION_SHORT_NAME);
73: CURSOR RESP_KEY (resp_appl_id number, resp_resp_name varchar2)IS
74: select responsibility_key
75: from fnd_responsibility_vl
76: where responsibility_name = resp_resp_name
77: and application_id = resp_appl_id;
78: BEGIN
79: OPEN C_APPL;