APPS.EGO_VS_BULKLOAD_PVT dependencies on EGO_VALUE_SET_EXT

Line 3962: FROM Ego_value_Set_Ext evse

3958: WHERE ffvs.flex_value_set_id= efvsv.flex_value_set_id
3959: )
3960: AND NOT EXISTS
3961: ( SELECT 1
3962: FROM Ego_value_Set_Ext evse
3963: WHERE ffvs.flex_value_set_id = evse.value_set_id
3964: )
3965:
3966: AND ffvs.parent_flex_value_set_id IS NULL

Line 4062: FROM Ego_value_Set_Ext evse

4058: WHERE ffvs.flex_value_set_id= efvsv.flex_value_set_id
4059: )
4060: AND NOT EXISTS
4061: ( SELECT 1
4062: FROM Ego_value_Set_Ext evse
4063: WHERE ffvs.flex_value_set_id = evse.value_set_id
4064: )
4065: AND evsvi.version_seq_id IS NULL
4066: )

Line 4330: FROM Ego_value_Set_Ext evse

4326: )
4327:
4328: AND EXISTS
4329: ( SELECT 1
4330: FROM Ego_value_Set_Ext evse
4331: WHERE ffvs.flex_value_set_id = evse.value_set_id
4332: )
4333: )
4334:

Line 4519: FROM Ego_Value_Set_Ext evse

4515: WHERE ffvs.flex_value_set_id= efvsv.flex_value_set_id
4516: )
4517: AND NOT EXISTS
4518: ( SELECT 1
4519: FROM Ego_Value_Set_Ext evse
4520: WHERE ffvs.flex_value_set_id= evse.value_set_id
4521: )
4522:
4523: AND ffvs.parent_flex_value_set_id IS NULL

Line 4576: FROM Ego_Value_Set_Ext evse

4572: WHERE ffvs.flex_value_set_id= efvsv.flex_value_set_id
4573: )
4574: AND NOT EXISTS
4575: ( SELECT 1
4576: FROM Ego_Value_Set_Ext evse
4577: WHERE ffvs.flex_value_set_id= evse.value_set_id
4578: )
4579:
4580: AND ffvs.parent_flex_value_set_id IS NULL

Line 10647: FROM Ego_Value_Set_Ext

10643: --Cursor to verify if parent_value_set_name already exist, in case of Update API.
10644: CURSOR cur_valid_parent( cp_value_set_id NUMBER,
10645: cp_parent_vs_id NUMBER) IS
10646: SELECT 1 AS valid_parent
10647: FROM Ego_Value_Set_Ext
10648: WHERE value_set_id = cp_value_set_id
10649: AND parent_value_set_id = cp_parent_vs_id;
10650:
10651: