DBA Data[Home] [Help]

APPS.HR_NO_UTILITY dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 923: FROM pay_user_column_instances_f

919:
920: /*
921: CURSOR csr_get_user_table_value (l_user_column_id NUMBER, l_user_row_id NUMBER) IS
922: SELECT value
923: FROM pay_user_column_instances_f
924: WHERE legislation_code = 'NO'
925: AND user_column_id = l_user_column_id
926: AND user_row_id = l_user_row_id
927: AND fnd_date.canonical_to_date(p_Date_Earned) BETWEEN effective_start_date AND effective_end_date;

Line 933: FROM pay_user_column_instances_f

929:
930: /*
931: CURSOR csr_get_user_table_value (l_user_column_id NUMBER, l_user_row_id NUMBER) IS
932: SELECT value
933: FROM pay_user_column_instances_f
934: WHERE legislation_code = 'NO'
935: AND user_column_id = l_user_column_id
936: AND user_row_id = l_user_row_id
937: AND p_Date_Earned BETWEEN effective_start_date AND effective_end_date;

Line 946: FROM pay_user_column_instances_f

942: -- Using fnd_number.canonical_to_number on column value.
943:
944: CURSOR csr_get_user_table_value (l_user_column_id NUMBER, l_user_row_id NUMBER) IS
945: SELECT fnd_number.canonical_to_number(value)
946: FROM pay_user_column_instances_f
947: WHERE legislation_code = 'NO'
948: AND user_column_id = l_user_column_id
949: AND user_row_id = l_user_row_id
950: AND p_Date_Earned BETWEEN effective_start_date AND effective_end_date;