DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on ENG_LIFECYCLE_STATUSES

Line 4098: FROM eng_lifecycle_statuses els

4094: -- for TTM case since the processing is per organization and the submit change
4095: -- would have been enabled this is not going to be called
4096: CURSOR c_get_init_status IS
4097: SELECT els.status_code
4098: FROM eng_lifecycle_statuses els
4099: WHERE els.entity_id1 = p_local_change_id
4100: AND els.entity_name = 'ENG_CHANGE'
4101: AND els.sequence_number =
4102: (SELECT min(sequence_number)

Line 4103: FROM eng_lifecycle_statuses els1, eng_change_statuses_vl ecs1

4099: WHERE els.entity_id1 = p_local_change_id
4100: AND els.entity_name = 'ENG_CHANGE'
4101: AND els.sequence_number =
4102: (SELECT min(sequence_number)
4103: FROM eng_lifecycle_statuses els1, eng_change_statuses_vl ecs1
4104: WHERE els1.entity_id1 = p_local_change_id
4105: AND els1.entity_name = 'ENG_CHANGE'
4106: AND els1.status_code = ecs1.status_code
4107: AND ((ecs1.status_type = 4 AND l_schedule_immediately = 'Y')