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 3463: ,pay_user_columns col

3459: SELECT max(urw.ROW_HIGH_RANGE) ROW_HIGH_RANGE
3460: ,min(urw.ROW_LOW_RANGE_OR_NAME) ROW_LOW_RANGE_OR_NAME
3461: FROM pay_user_column_instances_f cin
3462: ,pay_user_rows_f urw
3463: ,pay_user_columns col
3464: WHERE col.user_table_id = p_user_table_id
3465: AND col.user_column_name = p_pay_plan||'-'||p_grade_or_level
3466: AND urw.user_table_id = p_user_table_id
3467: AND cin.user_row_id = urw.user_row_id

Line 4041: ,pay_user_columns col

4037: ,cin.effective_end_date
4038: ,col.user_column_name step
4039: FROM pay_user_column_instances_f cin
4040: ,pay_user_rows_f urw
4041: ,pay_user_columns col
4042: WHERE col.user_table_id = p_user_table_id
4043: -- AND col.user_column_name = p_step_or_rate
4044: AND urw.user_table_id = p_user_table_id
4045: --Bug# 7046241 added decode for pay plan GP