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 3944: FROM ego_attrs_v

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

Line 6400: from ego_attrs_v

6396: Cursor c_get_unique_key (p_attr_group_name IN NUMBER,
6397: p_attr_group_type IN NUMBER,
6398: p_application_id IN NUMBER) IS
6399: select attr_name, database_column
6400: from ego_attrs_v
6401: where attr_group_name = p_attr_group_name
6402: and attr_group_type = p_attr_group_type
6403: and application_id = p_application_id
6404: and unique_key_flag = 'Y';