DBA Data[Home] [Help]

APPS.PAY_SE_ABSENCE_USER dependencies on FND_NUMBER

Line 137: SELECT fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) INTO

133: --p_input_value5 := l_abs_cat_meaning;
134: p_input_value_name6 := 'CREATOR_ID';
135: p_input_value6 := p_absence_attendance_id;
136:
137: SELECT fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) INTO
138: l_absence_percentage
139: FROM PER_ABSENCE_ATTENDANCES PAA
140: WHERE PAA.ABSENCE_ATTENDANCE_ID =p_absence_attendance_id;
141:

Line 607: ,fnd_number.canonical_to_number(peevf4.SCREEN_ENTRY_VALUE) Absence_Percentage

603: --csr_v_earn_end_date DATE)
604: IS
605: SELECT fnd_date.canonical_to_date(peevf1.SCREEN_ENTRY_VALUE) start_date
606: ,fnd_date.canonical_to_date(peevf2.SCREEN_ENTRY_VALUE) end_date
607: ,fnd_number.canonical_to_number(peevf4.SCREEN_ENTRY_VALUE) Absence_Percentage
608: FROM per_all_assignments_f paaf
609: ,pay_element_types_f et
610: ,pay_element_entries_f ee
611: ,pay_element_entry_values_f peevf1