DBA Data[Home] [Help]

APPS.HR_INTEGRATION_UTILS dependencies on FND_RESPONSIBILITY_VL

Line 1152: FROM fnd_responsibility_vl

1148: --
1149: -- Cursor to determine resp_id
1150: CURSOR csr_get_resp_id(l_app_id IN number, l_resp_name IN varchar2) IS
1151: SELECT responsibility_id
1152: FROM fnd_responsibility_vl
1153: WHERE application_id = l_app_id
1154: AND responsibility_name = l_resp_name;
1155: --
1156: BEGIN

Line 1262: FROM fnd_responsibility_vl

1258: WHERE upper(application_short_name) = upper(p_resp_application);
1259: --
1260: CURSOR csr_chk_resp_exists(l_app_id IN number, l_resp_name IN varchar2) IS
1261: SELECT responsibility_id
1262: FROM fnd_responsibility_vl
1263: WHERE application_id = l_app_id
1264: AND responsibility_name = l_resp_name;
1265: --
1266: BEGIN