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_ES_CALC_SS_EARNINGS dependencies on FND_DATE

Line 514: SELECT nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy')) end_date

510: ,p_Rate_formula OUT NOCOPY VARCHAR2
511: ,p_Duration_Formula OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
512: --
513: CURSOR csr_wc_eit_nd_sd IS
514: SELECT nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy')) end_date
515: ,0 PU_perc
516: ,fnd_date.canonical_to_date(hoi.org_information1) start_date
517: FROM hr_organization_information hoi
518: WHERE hoi.organization_id = p_work_center

Line 516: ,fnd_date.canonical_to_date(hoi.org_information1) start_date

512: --
513: CURSOR csr_wc_eit_nd_sd IS
514: SELECT nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy')) end_date
515: ,0 PU_perc
516: ,fnd_date.canonical_to_date(hoi.org_information1) start_date
517: FROM hr_organization_information hoi
518: WHERE hoi.organization_id = p_work_center
519: AND hoi.org_information_context IN ('ES_WC_NATURAL_DISASTER','ES_WC_SHUTDOWN')
520: AND p_date_between BETWEEN fnd_date.canonical_to_date(hoi.org_information1)

Line 520: AND p_date_between BETWEEN fnd_date.canonical_to_date(hoi.org_information1)

516: ,fnd_date.canonical_to_date(hoi.org_information1) start_date
517: FROM hr_organization_information hoi
518: WHERE hoi.organization_id = p_work_center
519: AND hoi.org_information_context IN ('ES_WC_NATURAL_DISASTER','ES_WC_SHUTDOWN')
520: AND p_date_between BETWEEN fnd_date.canonical_to_date(hoi.org_information1)
521: AND nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy'));
522: --
523: CURSOR csr_wc_eit_pu IS
524: SELECT nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy')) end_date

Line 521: AND nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy'));

517: FROM hr_organization_information hoi
518: WHERE hoi.organization_id = p_work_center
519: AND hoi.org_information_context IN ('ES_WC_NATURAL_DISASTER','ES_WC_SHUTDOWN')
520: AND p_date_between BETWEEN fnd_date.canonical_to_date(hoi.org_information1)
521: AND nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy'));
522: --
523: CURSOR csr_wc_eit_pu IS
524: SELECT nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy')) end_date
525: ,fnd_number.canonical_to_number(hoi.org_information3) PU_perc

Line 524: SELECT nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy')) end_date

520: AND p_date_between BETWEEN fnd_date.canonical_to_date(hoi.org_information1)
521: AND nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy'));
522: --
523: CURSOR csr_wc_eit_pu IS
524: SELECT nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy')) end_date
525: ,fnd_number.canonical_to_number(hoi.org_information3) PU_perc
526: ,fnd_date.canonical_to_date(hoi.org_information1) start_date
527: ,hoi.org_information5 Cal_metod
528: ,hoi.org_information6 Rate_formula

Line 526: ,fnd_date.canonical_to_date(hoi.org_information1) start_date

522: --
523: CURSOR csr_wc_eit_pu IS
524: SELECT nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy')) end_date
525: ,fnd_number.canonical_to_number(hoi.org_information3) PU_perc
526: ,fnd_date.canonical_to_date(hoi.org_information1) start_date
527: ,hoi.org_information5 Cal_metod
528: ,hoi.org_information6 Rate_formula
529: ,hoi.org_information7 Duration_Formula
530: FROM hr_organization_information hoi

Line 533: AND p_date_between BETWEEN fnd_date.canonical_to_date(hoi.org_information1)

529: ,hoi.org_information7 Duration_Formula
530: FROM hr_organization_information hoi
531: WHERE hoi.organization_id = p_work_center
532: AND hoi.org_information_context IN ('ES_WC_PARTIAL_UNEMPLOYMENT')
533: AND p_date_between BETWEEN fnd_date.canonical_to_date(hoi.org_information1)
534: AND nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy'));
535: --
536: BEGIN
537: --

Line 534: AND nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy'));

530: FROM hr_organization_information hoi
531: WHERE hoi.organization_id = p_work_center
532: AND hoi.org_information_context IN ('ES_WC_PARTIAL_UNEMPLOYMENT')
533: AND p_date_between BETWEEN fnd_date.canonical_to_date(hoi.org_information1)
534: AND nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy'));
535: --
536: BEGIN
537: --
538: IF p_PU = 'Y' THEN

Line 577: SELECT nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy')) end_date

573: ,p_Duration_Formula OUT NOCOPY VARCHAR2) RETURN VARCHAR2
574: IS
575: --
576: CURSOR csr_wc_pu_details IS
577: SELECT nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy')) end_date
578: ,fnd_number.canonical_to_number(hoi.org_information3) PU_perc
579: ,fnd_date.canonical_to_date(hoi.org_information1) start_date
580: ,hoi.org_information5 Cal_metod
581: ,hoi.org_information6 Rate_formula

Line 579: ,fnd_date.canonical_to_date(hoi.org_information1) start_date

575: --
576: CURSOR csr_wc_pu_details IS
577: SELECT nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy')) end_date
578: ,fnd_number.canonical_to_number(hoi.org_information3) PU_perc
579: ,fnd_date.canonical_to_date(hoi.org_information1) start_date
580: ,hoi.org_information5 Cal_metod
581: ,hoi.org_information6 Rate_formula
582: ,hoi.org_information7 Duration_Formula
583: FROM hr_organization_information hoi

Line 586: AND fnd_date.canonical_to_date(hoi.org_information1) BETWEEN p_period_start_date

582: ,hoi.org_information7 Duration_Formula
583: FROM hr_organization_information hoi
584: WHERE hoi.organization_id = p_work_center
585: AND hoi.org_information_context IN ('ES_WC_PARTIAL_UNEMPLOYMENT')
586: AND fnd_date.canonical_to_date(hoi.org_information1) BETWEEN p_period_start_date
587: AND p_period_end_date;
588: --
589: BEGIN
590: --

Line 650: ,GREATEST(fnd_date.canonical_to_date(org_information5), p_start_date) l_bu_start_date

646: CURSOR csr_legal_employer_info(l_legal_emp_id IN NUMBER) IS
647: SELECT org_information2 l_bu_calc_method
648: ,org_information3 l_bu_daily_rate_ff
649: ,org_information4 l_bu_duration_ff
650: ,GREATEST(fnd_date.canonical_to_date(org_information5), p_start_date) l_bu_start_date
651: ,LEAST(nvl(fnd_date.canonical_to_date(org_information6),to_date('31-12-4712','dd-mm-yyyy')),p_end_date) l_bu_end_date
652: FROM hr_organization_information
653: WHERE organization_id = l_legal_emp_id
654: AND org_information_context = 'ES_BENEFIT_UPLIFT'

Line 651: ,LEAST(nvl(fnd_date.canonical_to_date(org_information6),to_date('31-12-4712','dd-mm-yyyy')),p_end_date) l_bu_end_date

647: SELECT org_information2 l_bu_calc_method
648: ,org_information3 l_bu_daily_rate_ff
649: ,org_information4 l_bu_duration_ff
650: ,GREATEST(fnd_date.canonical_to_date(org_information5), p_start_date) l_bu_start_date
651: ,LEAST(nvl(fnd_date.canonical_to_date(org_information6),to_date('31-12-4712','dd-mm-yyyy')),p_end_date) l_bu_end_date
652: FROM hr_organization_information
653: WHERE organization_id = l_legal_emp_id
654: AND org_information_context = 'ES_BENEFIT_UPLIFT'
655: AND org_information1 = p_abs_cat

Line 656: AND ((p_start_date BETWEEN fnd_date.canonical_to_date(ORG_INFORMATION5)

652: FROM hr_organization_information
653: WHERE organization_id = l_legal_emp_id
654: AND org_information_context = 'ES_BENEFIT_UPLIFT'
655: AND org_information1 = p_abs_cat
656: AND ((p_start_date BETWEEN fnd_date.canonical_to_date(ORG_INFORMATION5)
657: AND NVL(fnd_date.canonical_to_date(ORG_INFORMATION6),to_date('31-12-4712','DD-MM-YYYY')))
658: OR (fnd_date.canonical_to_date(ORG_INFORMATION5) BETWEEN p_start_date
659: AND p_end_date))
660: ORDER BY org_information5 ;

Line 657: AND NVL(fnd_date.canonical_to_date(ORG_INFORMATION6),to_date('31-12-4712','DD-MM-YYYY')))

653: WHERE organization_id = l_legal_emp_id
654: AND org_information_context = 'ES_BENEFIT_UPLIFT'
655: AND org_information1 = p_abs_cat
656: AND ((p_start_date BETWEEN fnd_date.canonical_to_date(ORG_INFORMATION5)
657: AND NVL(fnd_date.canonical_to_date(ORG_INFORMATION6),to_date('31-12-4712','DD-MM-YYYY')))
658: OR (fnd_date.canonical_to_date(ORG_INFORMATION5) BETWEEN p_start_date
659: AND p_end_date))
660: ORDER BY org_information5 ;
661: --

Line 658: OR (fnd_date.canonical_to_date(ORG_INFORMATION5) BETWEEN p_start_date

654: AND org_information_context = 'ES_BENEFIT_UPLIFT'
655: AND org_information1 = p_abs_cat
656: AND ((p_start_date BETWEEN fnd_date.canonical_to_date(ORG_INFORMATION5)
657: AND NVL(fnd_date.canonical_to_date(ORG_INFORMATION6),to_date('31-12-4712','DD-MM-YYYY')))
658: OR (fnd_date.canonical_to_date(ORG_INFORMATION5) BETWEEN p_start_date
659: AND p_end_date))
660: ORDER BY org_information5 ;
661: --
662: CURSOR csr_get_le_details (p_wc_organization_id NUMBER) IS