DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on ENG_CHANGE_ORDER_REVISIONS

Line 1840: FROM eng_change_order_revisions

1836: ge Notice*/
1837:
1838: CURSOR c_eco_revision IS
1839: SELECT *
1840: FROM eng_change_order_revisions
1841: WHERE change_notice = p_change_notice
1842: AND organization_id = l_org_hierarchy_level_id;
1843:
1844: /* Cursor to Pick all Revised Items for the Top Organization for the given Chan

Line 4232: FROM eng_change_order_revisions

4228: -- Cursor to Pick all Revised Items for the Top Organization for the given
4229: -- Change Notice
4230: CURSOR c_eco_revision IS
4231: SELECT *
4232: FROM eng_change_order_revisions
4233: WHERE change_notice = p_change_notice
4234: AND organization_id = p_organization_id
4235: AND nvl(start_date, sysdate) > sysdate; -- Added this condtion as only future revisions need to be fetched
4236: /* Cursor to fetch the group name given the party id */