DBA Data[Home] [Help]

APPS.PAY_DK_ABSENCE_USER dependencies on FND_NUMBER

Line 1077: fnd_number.canonical_to_number(abs_information7) part_time_hours,

1073: ,p_payment_during_leave OUT NOCOPY VARCHAR2 /* 11694807 */
1074: ) Return varchar2 is
1075: CURSOR csr_absence IS SELECT
1076: fnd_date.canonical_to_date(abs_information4) actual_dob,
1077: fnd_number.canonical_to_number(abs_information7) part_time_hours,
1078: abs_information8 part_time_hrs_freq,
1079: abs_information5 holiday_accrual
1080: ,abs_information6 payment_during_leave -- 11694807
1081: FROM PER_ABSENCE_ATTENDANCES PAA

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

1107: ,p_weekly_worked_days OUT NOCOPY NUMBER
1108: ) return Varchar2 is
1109:
1110: CURSOR csr_asg_le IS SELECT
1111: fnd_number.canonical_to_number(nvl(asg.normal_hours,hoi.org_information3)) hours
1112: ,nvl(asg.frequency,hoi.org_information4) frequency
1113: ,segment10 work_pattern
1114: FROM
1115: hr_organization_information hoi