DBA Data[Home] [Help]

APPS.PAY_DK_ABSENCE_USER dependencies on FND_NUMBER

Line 1041: fnd_number.canonical_to_number(abs_information7) part_time_hours,

1037: ,p_holiday_accrual OUT NOCOPY VARCHAR2
1038: ) Return varchar2 is
1039: CURSOR csr_absence IS SELECT
1040: fnd_date.canonical_to_date(abs_information4) actual_dob,
1041: fnd_number.canonical_to_number(abs_information7) part_time_hours,
1042: abs_information8 part_time_hrs_freq,
1043: abs_information5 holiday_accrual
1044: FROM PER_ABSENCE_ATTENDANCES PAA
1045: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;

Line 1073: fnd_number.canonical_to_number(nvl(asg.normal_hours,hoi.org_information3)) hours

1069: ,p_weekly_worked_days OUT NOCOPY NUMBER
1070: ) return Varchar2 is
1071:
1072: CURSOR csr_asg_le IS SELECT
1073: fnd_number.canonical_to_number(nvl(asg.normal_hours,hoi.org_information3)) hours
1074: ,nvl(asg.frequency,hoi.org_information4) frequency
1075: ,segment10 work_pattern
1076: FROM
1077: hr_organization_information hoi