DBA Data[Home] [Help]

APPS.GHR_SF52_UPDATE dependencies on PAY_USER_COLUMNS

Line 533: ,pay_user_columns col

529: CURSOR cur_pay IS
530: SELECT cin.value basic_pay
531: FROM pay_user_column_instances_f cin
532: ,pay_user_rows_f urw
533: ,pay_user_columns col
534: WHERE col.user_table_id = l_imm_pos_valid_grade.pay_table_id
535: AND urw.user_table_id = col.user_table_id
536: AND urw.row_low_range_or_name = l_pay_plan||'-'||l_grade_or_level
537: AND NVL(p_imm_pa_request_rec.effective_date,TRUNC(SYSDATE)) BETWEEN urw.effective_start_date AND urw.effective_end_date