[Home] [Help]
532:
533: CURSOR cur_pay IS
534: SELECT cin.value basic_pay
535: FROM pay_user_column_instances_f cin
536: ,pay_user_rows_f urw
537: ,pay_user_columns col
538: WHERE col.user_table_id = l_imm_pos_valid_grade.pay_table_id
539: AND urw.user_table_id = col.user_table_id
540: AND urw.row_low_range_or_name = l_pay_plan||'-'||l_grade_or_level