APPS.ENG_DEFAULT_REVISED_ITEM dependencies on ENG_LIFECYCLE_STATUSES

Line 399: FROM eng_lifecycle_statuses els1

395: IS
396: SELECT ecsv.status_code , ecsv.status_type
397: FROM eng_change_statuses_vl ecsv
398: WHERE ecsv.status_code IN (SELECT els1.status_code
399: FROM eng_lifecycle_statuses els1
400: WHERE els1.entity_name='ENG_CHANGE'
401: AND els1.entity_id1 = cp_change_id
402: AND els1.active_flag = 'Y'
403: AND els1.sequence_number = (SELECT min(els2.sequence_number)

Line 404: FROM eng_lifecycle_statuses els2

400: WHERE els1.entity_name='ENG_CHANGE'
401: AND els1.entity_id1 = cp_change_id
402: AND els1.active_flag = 'Y'
403: AND els1.sequence_number = (SELECT min(els2.sequence_number)
404: FROM eng_lifecycle_statuses els2
405: WHERE els2.entity_name='ENG_CHANGE'
406: AND els2.entity_id1 = cp_change_id
407: AND els2.active_flag = 'Y'));
408:

Line 1364: FROM eng_lifecycle_statuses els1

1360: IS
1361: SELECT ecsv.status_code
1362: FROM eng_change_statuses_vl ecsv
1363: WHERE ecsv.status_code IN (SELECT els1.status_code
1364: FROM eng_lifecycle_statuses els1
1365: WHERE els1.entity_name='ENG_CHANGE'
1366: AND els1.entity_id1 = cp_change_id
1367: AND els1.active_flag = 'Y'
1368: AND els1.sequence_number = (SELECT min(els2.sequence_number)

Line 1369: FROM eng_lifecycle_statuses els2

1365: WHERE els1.entity_name='ENG_CHANGE'
1366: AND els1.entity_id1 = cp_change_id
1367: AND els1.active_flag = 'Y'
1368: AND els1.sequence_number = (SELECT min(els2.sequence_number)
1369: FROM eng_lifecycle_statuses els2
1370: WHERE els2.entity_name='ENG_CHANGE'
1371: AND els2.entity_id1 = cp_change_id
1372: AND els2.active_flag = 'Y'));
1373: CURSOR c_CheckApproval IS SELECT 1