16: FUNCTION get_apps_signin_person_id RETURN NUMBER IS
17:
18: CURSOR check_cho_resp IS
19: SELECT 1
20: FROM fnd_responsibility
21: WHERE application_id = 453
22: AND responsibility_key = 'HRI_DBI_CHIEF_HR_OFFICER'
23: AND fnd_global.resp_id = responsibility_id;
24:
59: --
60: CURSOR cur_resp_key
61: IS
62: SELECT responsibility_key
63: FROM FND_RESPONSIBILITY
64: WHERE responsibility_id = p_resp_id
65: AND application_id = p_resp_appl_id;
66: --
67: BEGIN