APPS.GHR_PAY_CALC dependencies on PAY_USER_COLUMNS

Line 754: ,pay_user_columns col

750: ,cin.effective_start_date
751: ,cin.effective_end_date
752: FROM pay_user_column_instances_f cin
753: ,pay_user_rows_f urw
754: ,pay_user_columns col
755: WHERE col.user_table_id = p_user_table_id
756: AND col.user_column_name = p_step_or_rate
757: AND urw.user_table_id = p_user_table_id
758: -- Bug# 5132113 getting the value of GS when pay plan is GP

Line 825: ,pay_user_columns col

821: CURSOR cur_default_pay IS
822: SELECT cin.value basic_pay
823: FROM pay_user_column_instances_f cin
824: ,pay_user_rows_f urw
825: ,pay_user_columns col
826: ,pay_user_tables utb
827: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name
828: AND col.user_table_id = utb.user_table_id
829: AND col.user_column_name = p_step_or_rate

Line 3249: ,pay_user_columns col

3245: SELECT max(urw.ROW_HIGH_RANGE) ROW_HIGH_RANGE
3246: ,min(urw.ROW_LOW_RANGE_OR_NAME) ROW_LOW_RANGE_OR_NAME
3247: FROM pay_user_column_instances_f cin
3248: ,pay_user_rows_f urw
3249: ,pay_user_columns col
3250: WHERE col.user_table_id = p_user_table_id
3251: AND col.user_column_name = p_pay_plan||'-'||p_grade_or_level
3252: AND urw.user_table_id = p_user_table_id
3253: AND cin.user_row_id = urw.user_row_id

Line 3826: ,pay_user_columns col

3822: ,cin.effective_end_date
3823: ,col.user_column_name step
3824: FROM pay_user_column_instances_f cin
3825: ,pay_user_rows_f urw
3826: ,pay_user_columns col
3827: WHERE col.user_table_id = p_user_table_id
3828: -- AND col.user_column_name = p_step_or_rate
3829: AND urw.user_table_id = p_user_table_id
3830: --Bug# 7046241 added decode for pay plan GP