DBA Data[Home] [Help]

APPS.GHR_SF52_UPDATE dependencies on PAY_USER_COLUMNS

Line 537: ,pay_user_columns col

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
541: AND NVL(p_imm_pa_request_rec.effective_date,TRUNC(SYSDATE)) BETWEEN urw.effective_start_date AND urw.effective_end_date