DBA Data[Home] [Help]

APPS.MSC_REL_WF dependencies on FND_APPLICATION_VL

Line 1880: FROM FND_APPLICATION_VL

1876: -- remember the initial context
1877: -- because validate_pjm will change the context to PJM oper unit
1878: SELECT APPLICATION_ID
1879: INTO l_application_id
1880: FROM FND_APPLICATION_VL
1881: WHERE APPLICATION_SHORT_NAME = 'MSC'
1882: and rownum =1 ;
1883:
1884: -- calling validate_pjm for 11.5 sources only

Line 2624: FROM FND_APPLICATION_VL

2620:
2621: begin
2622: SELECT APPLICATION_ID
2623: INTO l_application_id
2624: FROM FND_APPLICATION_VL
2625: WHERE APPLICATION_SHORT_NAME = 'MSC'
2626: and rownum =1 ;
2627:
2628: SELECT responsibility_id

Line 2638: FROM FND_APPLICATION_VL

2634: exception when no_data_found then
2635:
2636: SELECT APPLICATION_ID
2637: INTO l_application_id
2638: FROM FND_APPLICATION_VL
2639: WHERE APPLICATION_SHORT_NAME = 'MRP'
2640: and rownum = 1;
2641:
2642: SELECT responsibility_id

Line 2692: from fnd_application_vl

2688: lv_sql_stmt VARCHAR2(2000);
2689:
2690: cursor appl_short_name (p_appl_name IN VARCHAR2) IS
2691: select application_short_name
2692: from fnd_application_vl
2693: where application_name = p_appl_name;
2694:
2695: BEGIN
2696: