eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_ARCHIVE_EHOL dependencies on FND_DATE

Line 452: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);

448: ,g_msg_txt) ;
449:
450: hr_utility.set_location('RANGE_CODE:After Calling all parameters',2);
451:
452: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
453: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
454:
455:
456: OPEN csr_use_hol_card(g_legal_employer_id);

Line 453: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);

449:
450: hr_utility.set_location('RANGE_CODE:After Calling all parameters',2);
451:
452: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
453: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
454:
455:
456: OPEN csr_use_hol_card(g_legal_employer_id);
457: FETCH csr_use_hol_card INTO l_use_holiday_card_1;

Line 811: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);

807: fetch csr_pay_periods into pp;
808: l_canonical_start_date := pp.start_date;
809: l_canonical_end_date := pp.end_date;
810: */
811: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
812: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
813:
814: IF l_report_type = 'PYDKEHOLCA_ANN' THEN
815: l_canonical_start_date := to_date('01-01-'||g_year,'dd-mm-rrrr');

Line 812: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);

808: l_canonical_start_date := pp.start_date;
809: l_canonical_end_date := pp.end_date;
810: */
811: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
812: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
813:
814: IF l_report_type = 'PYDKEHOLCA_ANN' THEN
815: l_canonical_start_date := to_date('01-01-'||g_year,'dd-mm-rrrr');
816: l_canonical_end_date := to_date('31-12-'||g_year,'dd-mm-rrrr');

Line 1046: AND p_effective_date between fnd_date.canonical_to_date(AEI_INFORMATION1)

1042: FROM PER_ASSIGNMENT_EXTRA_INFO
1043: WHERE
1044: ASSIGNMENT_ID = p_asg_id
1045: AND INFORMATION_TYPE = 'DK_EHOLC_HPAY_RATE'
1046: AND p_effective_date between fnd_date.canonical_to_date(AEI_INFORMATION1)
1047: AND NVL(fnd_date.canonical_to_date(AEI_INFORMATION2),to_date('31-12-4712','dd-mm-rrrr'));
1048:
1049: l_hol_pay_percentage NUMBER;
1050:

Line 1047: AND NVL(fnd_date.canonical_to_date(AEI_INFORMATION2),to_date('31-12-4712','dd-mm-rrrr'));

1043: WHERE
1044: ASSIGNMENT_ID = p_asg_id
1045: AND INFORMATION_TYPE = 'DK_EHOLC_HPAY_RATE'
1046: AND p_effective_date between fnd_date.canonical_to_date(AEI_INFORMATION1)
1047: AND NVL(fnd_date.canonical_to_date(AEI_INFORMATION2),to_date('31-12-4712','dd-mm-rrrr'));
1048:
1049: l_hol_pay_percentage NUMBER;
1050:
1051: /* Cursor to fetch the Legal Employer level Holiday Entitlement */

Line 1853: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);

1849: ,g_test_submission
1850: ,g_company_terminating
1851: ,g_msg_txt) ;
1852:
1853: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
1854: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
1855:
1856:
1857: OPEN cur_report_type(l_payroll_action_id);

Line 1854: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);

1850: ,g_company_terminating
1851: ,g_msg_txt) ;
1852:
1853: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
1854: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
1855:
1856:
1857: OPEN cur_report_type(l_payroll_action_id);
1858: FETCH cur_report_type INTO l_report_type;