904: -- get the data level id's
905:
906: SELECT data_level_id
907: INTO l_supp_level_id
908: FROM ego_data_level_b
909: WHERE application_id = 177
910: AND attr_group_type = 'POS_SUPP_PROFMGMT_GROUP'
911: AND data_level_name = 'SUPP_LEVEL';
912:
911: AND data_level_name = 'SUPP_LEVEL';
912:
913: SELECT data_level_id
914: INTO l_supp_addr_level_id
915: FROM ego_data_level_b
916: WHERE application_id = 177
917: AND attr_group_type = 'POS_SUPP_PROFMGMT_GROUP'
918: AND data_level_name = 'SUPP_ADDR_LEVEL';
919: