DBA Data[Home] [Help]

APPS.MSC_REL_WF dependencies on FND_APPLICATION_VL

Line 1645: FROM FND_APPLICATION_VL

1641: -- remember the initial context
1642: -- because validate_pjm will change the context to PJM oper unit
1643: SELECT APPLICATION_ID
1644: INTO l_application_id
1645: FROM FND_APPLICATION_VL
1646: WHERE APPLICATION_SHORT_NAME = 'MSC'
1647: and rownum =1 ;
1648:
1649: -- calling validate_pjm for 11.5 sources only

Line 2373: FROM FND_APPLICATION_VL

2369:
2370: begin
2371: SELECT APPLICATION_ID
2372: INTO l_application_id
2373: FROM FND_APPLICATION_VL
2374: WHERE APPLICATION_SHORT_NAME = 'MSC'
2375: and rownum =1 ;
2376:
2377: SELECT responsibility_id

Line 2387: FROM FND_APPLICATION_VL

2383: exception when no_data_found then
2384:
2385: SELECT APPLICATION_ID
2386: INTO l_application_id
2387: FROM FND_APPLICATION_VL
2388: WHERE APPLICATION_SHORT_NAME = 'MRP'
2389: and rownum = 1;
2390:
2391: SELECT responsibility_id

Line 2441: from fnd_application_vl

2437: lv_sql_stmt VARCHAR2(2000);
2438:
2439: cursor appl_short_name (p_appl_name IN VARCHAR2) IS
2440: select application_short_name
2441: from fnd_application_vl
2442: where application_name = p_appl_name;
2443:
2444: BEGIN
2445: