APPS.CS_SR_EXTATTRIBUTES_PVT dependencies on EGO_ATTRS_V

Line 2029: FROM ego_attrs_v

2025: ,p_ext_attr_tbl IN OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE) IS
2026:
2027: CURSOR c_get_attr_cur IS
2028: SELECT database_column, attr_name
2029: FROM ego_attrs_v
2030: WHERE application_id = p_application_id
2031: AND attr_group_type = p_attr_group_type
2032: AND attr_group_name = p_attr_group_name;
2033:

Line 2114: from ego_attrs_v

2110: p_attr_group_name IN VARCHAR2,
2111: p_attr_group_type IN VARCHAR2
2112: ) IS
2113: select attr_name, database_column
2114: from ego_attrs_v
2115: where attr_group_name = p_attr_group_name
2116: and attr_group_type = p_attr_group_type
2117: and application_id = p_application_id
2118: and unique_key_flag = 'Y';

Line 3029: from ego_attrs_v

3025: p_attr_group_name IN VARCHAR2,
3026: p_attr_group_type IN VARCHAR2
3027: ) IS
3028: select attr_name, database_column
3029: from ego_attrs_v
3030: where attr_group_name = p_attr_group_name
3031: and attr_group_type = p_attr_group_type
3032: and application_id = p_application_id
3033: and unique_key_flag = 'Y';

Line 3946: FROM ego_attrs_v

3942: ATTR_GROUP_NAME,
3943: attr_name,
3944: attr_display_name,
3945: database_column
3946: FROM ego_attrs_v
3947: WHERE application_id = p_application_id
3948: AND attr_group_type = p_attr_group_type
3949: AND attr_group_name = p_attr_group_name
3950: AND enabled_flag = 'Y'

Line 6427: from ego_attrs_v

6423: Cursor c_get_unique_key (p_attr_group_name IN NUMBER,
6424: p_attr_group_type IN NUMBER,
6425: p_application_id IN NUMBER) IS
6426: select attr_name, database_column
6427: from ego_attrs_v
6428: where attr_group_name = p_attr_group_name
6429: and attr_group_type = p_attr_group_type
6430: and application_id = p_application_id
6431: and unique_key_flag = 'Y';