DBA Data[Home] [Help]

APPS.AMW_UTILITY_PVT dependencies on AMW_PROCESS_OBJECTIVES_VL

Line 1307: FROM AMW_PROCESS_OBJECTIVES_VL APV,

1303: is
1304: l_dummy varchar2(80):=null;
1305: begin
1306: SELECT APV.name into l_dummy
1307: FROM AMW_PROCESS_OBJECTIVES_VL APV,
1308: AMW_OBJECTIVE_ASSOCIATIONS AOA
1309: WHERE
1310: APV.PROCESS_OBJECTIVE_ID =AOA.PROCESS_OBJECTIVE_ID
1311: AND AOA.PK1 = p_org_id

Line 1371: FROM AMW_PROCESS_OBJECTIVES_VL APV,

1367: is
1368: l_dummy varchar2(80):=null;
1369: begin
1370: SELECT APV.name into l_dummy
1371: FROM AMW_PROCESS_OBJECTIVES_VL APV,
1372: AMW_OBJECTIVE_ASSOCIATIONS AOA
1373: WHERE
1374: APV.PROCESS_OBJECTIVE_ID =AOA.PROCESS_OBJECTIVE_ID
1375: AND AOA.PK1 = p_org_id