APPS.BOM_EXPLODER_PUB dependencies on EGO_MINOR_REVISIONS

Line 1242: SELECT nvl(max(minor_revision_id),0) minor_revision_id FROM ego_minor_revisions

1238: CURSOR getCurrentMinorRev (p_obj_name IN VARCHAR2,
1239: p_pk1_value IN VARCHAR2,
1240: p_pk2_value IN VARCHAR2,
1241: p_pk3_value IN VARCHAR2) IS
1242: SELECT nvl(max(minor_revision_id),0) minor_revision_id FROM ego_minor_revisions
1243: WHERE obj_name = p_obj_name AND
1244: pk1_value = p_pk1_value AND
1245: nvl(pk2_value,'-1') = nvl(p_pk2_value,'-1') AND
1246: nvl(pk3_value,'-1') = nvl(p_pk3_value,'-1');

Line 2812: SELECT nvl(max(minor_revision_id),0) minor_revision_id FROM ego_minor_revisions

2808: CURSOR getCurrentMinorRev (p_obj_name IN VARCHAR2,
2809: p_pk1_value IN VARCHAR2,
2810: p_pk2_value IN VARCHAR2,
2811: p_pk3_value IN VARCHAR2) IS
2812: SELECT nvl(max(minor_revision_id),0) minor_revision_id FROM ego_minor_revisions
2813: WHERE obj_name = p_obj_name AND
2814: pk1_value = p_pk1_value AND
2815: nvl(pk2_value,'-1') = nvl(p_pk2_value,'-1') AND
2816: nvl(pk3_value,'-1') = nvl(p_pk3_value,'-1');

Line 2819: SELECT nvl(max(minor_revision_id),0) minor_revision_id FROM ego_minor_revisions

2815: nvl(pk2_value,'-1') = nvl(p_pk2_value,'-1') AND
2816: nvl(pk3_value,'-1') = nvl(p_pk3_value,'-1');
2817:
2818: CURSOR getCurrentMinorRevForItemRev (p_item_rev_id IN NUMBER) IS
2819: SELECT nvl(max(minor_revision_id),0) minor_revision_id FROM ego_minor_revisions
2820: WHERE obj_name = 'EGO_ITEM_REVISION'
2821: AND pk3_value = p_item_rev_id;
2822:
2823: CURSOR getEndItemMinorRevCode (p_revision_id IN NUMBER,