DBA Data[Home] [Help]

APPS.AMW_UTILITY_PVT dependencies on ENG_CHANGE_SUBJECTS

Line 1410: from eng_change_subjects ecs

1406: BEGIN
1407:
1408: if p_org_id = -1 then
1409: select max(ecs.change_id) INTO l_dummy
1410: from eng_change_subjects ecs
1411: ,eng_engineering_changes eec
1412: where ecs.entity_name='AMW_REVISION_ETTY'
1413: and ecs.pk1_value=p_proc_id
1414: and ecs.pk2_value=p_rev_num

Line 1420: from eng_change_subjects ecs, eng_engineering_changes eec

1416: and ecs.change_id=eec.change_id
1417: and eec.status_type <> 5;
1418: else
1419: select max(ecs.change_id) INTO l_dummy
1420: from eng_change_subjects ecs, eng_engineering_changes eec
1421: where ecs.entity_name='AMW_ORG_REV_ETTY'
1422: and ecs.pk1_value=p_org_id
1423: and ecs.pk2_value=p_proc_id
1424: and ecs.pk3_value=p_rev_num