APPS.GHR_PC_BASIC_PAY dependencies on PAY_USER_COLUMNS

Line 423: ,pay_user_columns col

419: ,cin.effective_start_date
420: ,cin.effective_end_date
421: FROM pay_user_column_instances_f cin
422: ,pay_user_rows_f urw
423: ,pay_user_columns col
424: WHERE col.user_table_id = p_user_table_id
425: AND urw.user_table_id = p_user_table_id
426: AND urw.row_low_range_or_name = p_pay_plan||'-'||p_grade_or_level
427: AND NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN urw.effective_start_date AND urw.effective_end_date

Line 502: ,pay_user_columns col

498: ,cin.effective_start_date
499: ,cin.effective_end_date
500: FROM pay_user_column_instances_f cin
501: ,pay_user_rows_f urw
502: ,pay_user_columns col
503: WHERE col.user_table_id = p_user_table_id
504: AND urw.user_table_id = p_user_table_id
505: AND urw.row_low_range_or_name = p_pay_plan||'-'||p_grade_or_level
506: AND NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN urw.effective_start_date AND urw.effective_end_date

Line 590: ,pay_user_columns col

586: ,cin.effective_start_date
587: ,cin.effective_end_date
588: FROM pay_user_column_instances_f cin
589: ,pay_user_rows_f urw
590: ,pay_user_columns col
591: WHERE col.user_table_id = p_user_table_id
592: AND urw.user_table_id = p_user_table_id
593: AND urw.row_low_range_or_name = p_pay_plan||'-'||p_grade_or_level
594: AND NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN urw.effective_start_date AND urw.effective_end_date

Line 699: ,pay_user_columns col

695: ,cin.effective_start_date
696: ,cin.effective_end_date
697: FROM pay_user_column_instances_f cin
698: ,pay_user_rows_f urw
699: ,pay_user_columns col
700: WHERE col.user_table_id = p_user_table_id
701: AND urw.user_table_id = p_user_table_id
702: AND urw.row_low_range_or_name = p_pay_plan||'-'||p_grade_or_level
703: AND NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN urw.effective_start_date AND urw.effective_end_date