DBA Data[Home] [Help]

APPS.HR_INTEGRATION_UTILS dependencies on FND_RESPONSIBILITY_VL

Line 1139: FROM fnd_responsibility_vl

1135: --
1136: -- Cursor to determine resp_id
1137: CURSOR csr_get_resp_id(l_app_id IN number, l_resp_name IN varchar2) IS
1138: SELECT responsibility_id
1139: FROM fnd_responsibility_vl
1140: WHERE application_id = l_app_id
1141: AND responsibility_name = l_resp_name;
1142: --
1143: BEGIN

Line 1249: FROM fnd_responsibility_vl

1245: WHERE upper(application_short_name) = upper(p_resp_application);
1246: --
1247: CURSOR csr_chk_resp_exists(l_app_id IN number, l_resp_name IN varchar2) IS
1248: SELECT responsibility_id
1249: FROM fnd_responsibility_vl
1250: WHERE application_id = l_app_id
1251: AND responsibility_name = l_resp_name;
1252: --
1253: BEGIN