[Home] [Help]
520:
521: DELETE psb_pay_element_options
522: WHERE pay_element_id = l_pay_element_id ;
523:
524: DELETE psb_pay_element_distributions
525: WHERE position_set_group_id IN
526: (
527: SELECT position_set_group_id
528: FROM psb_element_pos_set_groups
1192: segment23,segment24,
1193: segment25,segment26,
1194: segment27,segment28,
1195: segment29,segment30
1196: FROM psb_pay_element_distributions
1197: WHERE position_set_group_id = l_source_set_group_id
1198: order by distribution_set_id;
1199:
1200: BEGIN