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 3461: FROM pay_user_column_instances_f cin

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

Line 4039: FROM pay_user_column_instances_f cin

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