APPS.PAY_DK_SICKNESS_DP201 dependencies on FND_DATE

Line 358: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2) and fnd_date.canonical_to_date(hoi.org_information3)

354: hr_organization_information hoi
355: WHERE
356: hoi.organization_id = p_le_id
357: AND hoi.org_information_context = 'DK_SICKPAY_DEFAULTS'
358: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2) and fnd_date.canonical_to_date(hoi.org_information3)
359: ORDER BY hoi.org_information2;
360:
361: CURSOR csr_le_work_pattern(p_org_id NUMBER) is
362: SELECT

Line 414: l_start_date :=FND_DATE.CANONICAL_TO_DATE(p_start_date);

410: BEGIN
411: l_check := 'X';
412: xml_ctr := 0;
413: l_work_pattern := '5DAY'; -- By default work pattern is 5 days
414: l_start_date :=FND_DATE.CANONICAL_TO_DATE(p_start_date);
415: l_end_date :=FND_DATE.CANONICAL_TO_DATE(p_end_date);
416:
417:
418: FOR asg_rec IN csr_asg LOOP

Line 415: l_end_date :=FND_DATE.CANONICAL_TO_DATE(p_end_date);

411: l_check := 'X';
412: xml_ctr := 0;
413: l_work_pattern := '5DAY'; -- By default work pattern is 5 days
414: l_start_date :=FND_DATE.CANONICAL_TO_DATE(p_start_date);
415: l_end_date :=FND_DATE.CANONICAL_TO_DATE(p_end_date);
416:
417:
418: FOR asg_rec IN csr_asg LOOP
419: l_absence_days := NVL(asg_rec.absence_end_date,l_end_date) - asg_rec.absence_start_date+1;