APPS.ENG_ECO_PVT dependencies on ENG_CHANGE_OBJ_RELATIONSHIPS

Line 14085: select ENG_CHANGE_OBJ_RELATIONSHIPS_S.nextval

14081: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type ;
14082: l_new_prop_relation NUMBER;
14083: begin
14084:
14085: select ENG_CHANGE_OBJ_RELATIONSHIPS_S.nextval
14086: into l_new_prop_relation
14087: from dual;
14088:
14089: insert into eng_change_obj_relationships (

Line 14089: insert into eng_change_obj_relationships (

14085: select ENG_CHANGE_OBJ_RELATIONSHIPS_S.nextval
14086: into l_new_prop_relation
14087: from dual;
14088:
14089: insert into eng_change_obj_relationships (
14090: CHANGE_RELATIONSHIP_ID,
14091: CHANGE_ID,
14092: RELATIONSHIP_CODE,
14093: OBJECT_TO_NAME,

Line 17203: CURSOR c_propagated_change_order(cp_change_notice eng_engineering_changes.change_notice%type, cp_local_organization_id eng_change_obj_relationships.object_to_id3%type)

17199: FROM ENG_SECURITY_GROUP_MEMBERS_V
17200: WHERE GROUP_ID = cp_group_id
17201: ORDER BY MEMBER_PERSON_ID;
17202:
17203: CURSOR c_propagated_change_order(cp_change_notice eng_engineering_changes.change_notice%type, cp_local_organization_id eng_change_obj_relationships.object_to_id3%type)
17204: IS
17205: SELECT eec.change_id
17206: FROM eng_engineering_changes eec ,
17207: eng_change_obj_relationships ecor

Line 17207: eng_change_obj_relationships ecor

17203: CURSOR c_propagated_change_order(cp_change_notice eng_engineering_changes.change_notice%type, cp_local_organization_id eng_change_obj_relationships.object_to_id3%type)
17204: IS
17205: SELECT eec.change_id
17206: FROM eng_engineering_changes eec ,
17207: eng_change_obj_relationships ecor
17208: WHERE eec.change_id = ecor.object_to_id1
17209: AND ecor.relationship_code IN ( 'PROPAGATED_TO', 'TRANSFERRED_TO' )
17210: AND ecor.object_to_name ='ENG_CHANGE'
17211: AND ecor.object_to_id3 = cp_local_organization_id