APPS.PAY_DK_ABSENCE_USER dependencies on FND_DATE

Line 359: fnd_date.canonical_to_date(abs_information4) expected_dob,

355: ,p_maternity_weeks_transfer OUT NOCOPY NUMBER
356: ,p_holiday_accrual OUT NOCOPY VARCHAR2
357: ) Return varchar2 is
358: CURSOR csr_absence IS SELECT
359: fnd_date.canonical_to_date(abs_information4) expected_dob,
360: fnd_date.canonical_to_date(abs_information5) actual_dob,
361: abs_information8 pre_birth_duration,
362: abs_information9 post_birth_duration,
363: abs_information10 maternity_weeks_transfer,

Line 360: fnd_date.canonical_to_date(abs_information5) actual_dob,

356: ,p_holiday_accrual OUT NOCOPY VARCHAR2
357: ) Return varchar2 is
358: CURSOR csr_absence IS SELECT
359: fnd_date.canonical_to_date(abs_information4) expected_dob,
360: fnd_date.canonical_to_date(abs_information5) actual_dob,
361: abs_information8 pre_birth_duration,
362: abs_information9 post_birth_duration,
363: abs_information10 maternity_weeks_transfer,
364: abs_information6 holiday_accrual

Line 379: AND fnd_date.canonical_to_date(p_date_earned) BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE;

375: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
376: AND hoi.organization_id = scl.segment1
377: AND org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
378: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
379: AND fnd_date.canonical_to_date(p_date_earned) BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE;
380: l_count VARCHAR2(2):='N';
381: l_duration_freq VARCHAR2(80);
382: Begin
383: hr_utility.trace('****************Inside***************');

Line 588: fnd_date.canonical_to_date(abs_information4) expected_dob,

584: ,p_sex OUT NOCOPY VARCHAR2
585: ,p_holiday_accrual OUT NOCOPY VARCHAR2
586: ) Return NUMBER is
587: CURSOR csr_absence IS SELECT
588: fnd_date.canonical_to_date(abs_information4) expected_dob,
589: fnd_date.canonical_to_date(abs_information5) actual_dob,
590: abs_information8 pre_adopt_duration,
591: abs_information9 post_adopt_duration,
592: abs_information10 adoption_weeks_transfer,

Line 589: fnd_date.canonical_to_date(abs_information5) actual_dob,

585: ,p_holiday_accrual OUT NOCOPY VARCHAR2
586: ) Return NUMBER is
587: CURSOR csr_absence IS SELECT
588: fnd_date.canonical_to_date(abs_information4) expected_dob,
589: fnd_date.canonical_to_date(abs_information5) actual_dob,
590: abs_information8 pre_adopt_duration,
591: abs_information9 post_adopt_duration,
592: abs_information10 adoption_weeks_transfer,
593: abs_information11 weeks_from_mother,

Line 762: fnd_date.canonical_to_date(abs_information4) actual_dob,

758: ,p_parental_type OUT NOCOPY VARCHAR2
759: ,p_holiday_accrual OUT NOCOPY VARCHAR2
760: ) Return varchar2 is
761: CURSOR csr_absence IS SELECT
762: fnd_date.canonical_to_date(abs_information4) actual_dob,
763: abs_information7 duration_override,
764: abs_information10 parental_type,
765: abs_information5 holiday_accrual
766: FROM PER_ABSENCE_ATTENDANCES PAA

Line 1040: fnd_date.canonical_to_date(abs_information4) actual_dob,

1036: ,p_part_time_hrs_freq OUT NOCOPY VARCHAR2
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