APPS.AMW_UTILITY_PVT dependencies on AMW_OBJECTIVE_ASSOCIATIONS

Line 1308: AMW_OBJECTIVE_ASSOCIATIONS AOA

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
1312: AND AOA.PK2 = p_proc_id

Line 1329: FROM AMW_OBJECTIVE_ASSOCIATIONS AOA

1325: is
1326: l_dummy NUMBER :=null;
1327: begin
1328: SELECT AOA.PROCESS_OBJECTIVE_ID into l_dummy
1329: FROM AMW_OBJECTIVE_ASSOCIATIONS AOA
1330: WHERE
1331: AOA.PK1 = p_org_id
1332: AND AOA.PK2 = p_proc_id
1333: AND AOA.PK3 = p_risk_id

Line 1349: FROM AMW_OBJECTIVE_ASSOCIATIONS AOA

1345: is
1346: l_dummy DATE:=null;
1347: begin
1348: SELECT AOA.approval_date into l_dummy
1349: FROM AMW_OBJECTIVE_ASSOCIATIONS AOA
1350: WHERE AOA.PK1 = p_org_id
1351: AND AOA.PK2 = p_proc_id
1352: AND AOA.PK3 = p_risk_id
1353: AND AOA.PK4 = p_control_id

Line 1372: AMW_OBJECTIVE_ASSOCIATIONS AOA

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
1376: AND AOA.PK2 = p_proc_id

Line 1537: FROM AMW_OBJECTIVE_ASSOCIATIONS AOA

1533: is
1534: l_dummy DATE:=null;
1535: begin
1536: SELECT AOA.approval_date into l_dummy
1537: FROM AMW_OBJECTIVE_ASSOCIATIONS AOA
1538: WHERE AOA.PK1 = p_process_id
1539: AND AOA.PK2 = p_risk_id
1540: AND AOA.PK3 = p_control_id
1541: AND AOA.DELETION_DATE IS NULL