APPS.GHR_PAY_CALC dependencies on PAY_USER_ROWS_F

Line 753: ,pay_user_rows_f urw

749: SELECT cin.value basic_pay
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

Line 824: ,pay_user_rows_f urw

820: --
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

Line 3462: ,pay_user_rows_f urw

3458: CURSOR cur_pay IS
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

Line 4040: ,pay_user_rows_f urw

4036: ,cin.effective_start_date
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