DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on ENG_CHANGE_ORDER_REVISIONS

Line 1821: FROM eng_change_order_revisions

1817: ge Notice*/
1818:
1819: CURSOR c_eco_revision IS
1820: SELECT *
1821: FROM eng_change_order_revisions
1822: WHERE change_notice = p_change_notice
1823: AND organization_id = l_org_hierarchy_level_id;
1824:
1825: /* Cursor to Pick all Revised Items for the Top Organization for the given Chan

Line 4107: FROM eng_change_order_revisions

4103: -- Cursor to Pick all Revised Items for the Top Organization for the given
4104: -- Change Notice
4105: CURSOR c_eco_revision IS
4106: SELECT *
4107: FROM eng_change_order_revisions
4108: WHERE change_notice = p_change_notice
4109: AND organization_id = p_organization_id
4110: AND nvl(start_date, sysdate) > sysdate; -- Added this condtion as only future revisions need to be fetched
4111: /* Cursor to fetch the group name given the party id */