[Home] [Help]
579: ) is
580: --
581: CURSOR c_sdp_bg_check is
582: select distinct(pet.business_group_id) bg
583: from hxt_shift_diff_rules sdr
584: , pay_element_types_f pet
585: where sdr.sdp_id = p_sdp_id
586: and sdr.element_type_id = pet.element_type_id
587: and pet.business_group_id is not null;