DBA Data[Home] [Help]

APPS.HR_NO_UTILITY dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 999: FROM pay_user_column_instances_f

995:
996: /*
997: CURSOR csr_get_user_table_value (l_user_column_id NUMBER, l_user_row_id NUMBER) IS
998: SELECT value
999: FROM pay_user_column_instances_f
1000: WHERE legislation_code = 'NO'
1001: AND user_column_id = l_user_column_id
1002: AND user_row_id = l_user_row_id
1003: AND fnd_date.canonical_to_date(p_Date_Earned) BETWEEN effective_start_date AND effective_end_date;

Line 1009: FROM pay_user_column_instances_f

1005:
1006: /*
1007: CURSOR csr_get_user_table_value (l_user_column_id NUMBER, l_user_row_id NUMBER) IS
1008: SELECT value
1009: FROM pay_user_column_instances_f
1010: WHERE legislation_code = 'NO'
1011: AND user_column_id = l_user_column_id
1012: AND user_row_id = l_user_row_id
1013: AND p_Date_Earned BETWEEN effective_start_date AND effective_end_date;

Line 1022: FROM pay_user_column_instances_f

1018: -- Using fnd_number.canonical_to_number on column value.
1019:
1020: CURSOR csr_get_user_table_value (l_user_column_id NUMBER, l_user_row_id NUMBER) IS
1021: SELECT fnd_number.canonical_to_number(value)
1022: FROM pay_user_column_instances_f
1023: WHERE legislation_code = 'NO'
1024: AND user_column_id = l_user_column_id
1025: AND user_row_id = l_user_row_id
1026: AND p_Date_Earned BETWEEN effective_start_date AND effective_end_date;