APPS.HR_INTEGRATION_UTILS dependencies on FND_APPLICATION

Line 1030: FROM fnd_application

1026: l_application_id number;
1027: --
1028: CURSOR csr_find_app_id IS
1029: SELECT application_id
1030: FROM fnd_application
1031: WHERE upper(application_short_name) = upper(p_application_short_name);
1032: --
1033: BEGIN
1034: --

Line 1146: FROM fnd_application

1142: --
1143: -- Cursor to determine app_id
1144: CURSOR csr_get_app_id(l_app_short_name IN varchar) IS
1145: SELECT application_id
1146: FROM fnd_application
1147: WHERE upper(application_short_name) = upper(l_app_short_name);
1148: --
1149: -- Cursor to determine resp_id
1150: CURSOR csr_get_resp_id(l_app_id IN number, l_resp_name IN varchar2) IS

Line 1257: FROM fnd_application

1253: WHERE resp_association_id = p_resp_association_id;
1254: --
1255: CURSOR csr_chk_app_exists IS
1256: SELECT application_id
1257: FROM fnd_application
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

Line 1360: FROM fnd_application

1356: --
1357: --
1358: CURSOR csr_chk_app_exists IS
1359: SELECT application_id
1360: FROM fnd_application
1361: WHERE upper(application_short_name) = upper(p_intg_application);
1362: --
1363: --
1364: BEGIN