APPS.HR_INTEGRATION_UTILS dependencies on FND_APPLICATION

Line 1017: FROM fnd_application

1013: l_application_id number;
1014: --
1015: CURSOR csr_find_app_id IS
1016: SELECT application_id
1017: FROM fnd_application
1018: WHERE upper(application_short_name) = upper(p_application_short_name);
1019: --
1020: BEGIN
1021: --

Line 1133: FROM fnd_application

1129: --
1130: -- Cursor to determine app_id
1131: CURSOR csr_get_app_id(l_app_short_name IN varchar) IS
1132: SELECT application_id
1133: FROM fnd_application
1134: WHERE upper(application_short_name) = upper(l_app_short_name);
1135: --
1136: -- Cursor to determine resp_id
1137: CURSOR csr_get_resp_id(l_app_id IN number, l_resp_name IN varchar2) IS

Line 1244: FROM fnd_application

1240: WHERE resp_association_id = p_resp_association_id;
1241: --
1242: CURSOR csr_chk_app_exists IS
1243: SELECT application_id
1244: FROM fnd_application
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

Line 1347: FROM fnd_application

1343: --
1344: --
1345: CURSOR csr_chk_app_exists IS
1346: SELECT application_id
1347: FROM fnd_application
1348: WHERE upper(application_short_name) = upper(p_intg_application);
1349: --
1350: --
1351: BEGIN