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 HR_ORGANIZATION_INFORMATION

Line 517: FROM hr_organization_information hoi

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)
521: AND nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31-12-4712','dd-mm-yyyy'));

Line 530: FROM hr_organization_information hoi

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
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'));

Line 583: FROM hr_organization_information hoi

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
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;

Line 652: FROM hr_organization_information

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
656: AND ((p_start_date BETWEEN fnd_date.canonical_to_date(ORG_INFORMATION5)

Line 664: FROM hr_organization_information hoi

660: ORDER BY org_information5 ;
661: --
662: CURSOR csr_get_le_details (p_wc_organization_id NUMBER) IS
663: SELECT hoi.organization_id le_id
664: FROM hr_organization_information hoi
665: WHERE hoi.org_information1 = p_wc_organization_id
666: AND hoi.org_information_context = 'ES_WORK_CENTER_REF';
667:
668:

Line 670: l_BU_Calculation hr_organization_information.org_information2%TYPE;

666: AND hoi.org_information_context = 'ES_WORK_CENTER_REF';
667:
668:
669: l_Benefit_Days NUMBER;
670: l_BU_Calculation hr_organization_information.org_information2%TYPE;
671: l_BU_Rate_Formula hr_organization_information.org_information2%TYPE;
672: l_BU_Duration_Formula hr_organization_information.org_information2%TYPE;
673: l_Day_Amount NUMBER;
674: l_Days_in_Value1 NUMBER := 0;

Line 671: l_BU_Rate_Formula hr_organization_information.org_information2%TYPE;

667:
668:
669: l_Benefit_Days NUMBER;
670: l_BU_Calculation hr_organization_information.org_information2%TYPE;
671: l_BU_Rate_Formula hr_organization_information.org_information2%TYPE;
672: l_BU_Duration_Formula hr_organization_information.org_information2%TYPE;
673: l_Day_Amount NUMBER;
674: l_Days_in_Value1 NUMBER := 0;
675: l_Days_in_Value2 NUMBER := 0;

Line 672: l_BU_Duration_Formula hr_organization_information.org_information2%TYPE;

668:
669: l_Benefit_Days NUMBER;
670: l_BU_Calculation hr_organization_information.org_information2%TYPE;
671: l_BU_Rate_Formula hr_organization_information.org_information2%TYPE;
672: l_BU_Duration_Formula hr_organization_information.org_information2%TYPE;
673: l_Day_Amount NUMBER;
674: l_Days_in_Value1 NUMBER := 0;
675: l_Days_in_Value2 NUMBER := 0;
676: l_Days_in_Value3 NUMBER := 0;