APPS.GHR_PAY_CALC dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 752: FROM pay_user_column_instances_f cin

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

Line 823: FROM pay_user_column_instances_f cin

819: l_record_found BOOLEAN := FALSE;
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

Line 3247: FROM pay_user_column_instances_f cin

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

Line 3824: FROM pay_user_column_instances_f cin

3820: SELECT cin.value basic_pay
3821: ,cin.effective_start_date
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