APPS.PAY_SE_SLSA_ARCHIVE dependencies on STANDARD

Line 395: /* Cursor to get the standard work details from the 'Standard Work Details' EIT */

391: AND hoi1.org_information_context = 'CLASS'
392: AND o1.organization_id = hoi2.organization_id
393: AND hoi2.org_information_context = 'SE_LEGAL_EMPLOYER_DETAILS';
394:
395: /* Cursor to get the standard work details from the 'Standard Work Details' EIT */
396: CURSOR csr_get_std_work_details (
397: p_legal_employer_id hr_organization_information.organization_id%TYPE,
398: p_year hr_organization_information.org_information1%TYPE
399: ) IS

Line 596: /* Get the Standard working hours */

592: l_women_middle_age_count := 0;
593: l_women_upper_age_count := 0;
594: l_emp_work_hours := 0;
595: l_emp_sick_hours := 0;
596: /* Get the Standard working hours */
597: OPEN csr_get_std_work_details (p_legal_employer_id, to_char (p_effective_end_date, 'YYYY'));
598: FETCH csr_get_std_work_details INTO l_curr_week_hours, l_curr_daily_hours, l_curr_days_per_year, l_curr_hours_per_year;
599: CLOSE csr_get_std_work_details;
600:

Line 794: /* Find the Total sick leave related to total standard working hours */

790: + l_women_m_age_l_sick_leaves + l_men_m_age_l_sick_leaves + l_women_u_age_l_sick_leaves;
791:
792: --
793: /* Find the Statistics */
794: /* Find the Total sick leave related to total standard working hours */
795: IF l_org_total_work_hours > 0 THEN
796: l_leave_to_work_hours := round ((l_org_total_sick_hours / l_org_total_work_hours * 100), 1);
797: ELSE
798: l_leave_to_work_hours := 0;

Line 810: /* Find the Sick leave for women related to total standard working hours for women */

806: l_long_leave_part := 0;
807: END IF;
808:
809: --
810: /* Find the Sick leave for women related to total standard working hours for women */
811: IF l_org_tot_women_work_hours > 0 THEN
812: l_women_leave_to_work_hour := round ((l_org_tot_women_sick_hours / l_org_tot_women_work_hours * 100), 1);
813: ELSE
814: l_women_leave_to_work_hour := 0;

Line 817: /* Find the Sick leave for men related to total standard working hours for men */

813: ELSE
814: l_women_leave_to_work_hour := 0;
815: END IF;
816:
817: /* Find the Sick leave for men related to total standard working hours for men */
818: IF l_org_tot_men_work_hours > 0 THEN
819: l_men_leave_to_work_hour := round ((l_org_tot_men_sick_hours / l_org_tot_men_work_hours * 100), 1);
820: ELSE
821: l_men_leave_to_work_hour := 0;

Line 824: /* Find the Sick leave for the lower age group, related to the total standard working hours for this group */

820: ELSE
821: l_men_leave_to_work_hour := 0;
822: END IF;
823:
824: /* Find the Sick leave for the lower age group, related to the total standard working hours for this group */
825: IF l_org_tot_l_age_work_hours > 0 THEN
826: l_leave_to_work_hour_lower := round ((l_org_tot_l_age_sick_hours / l_org_tot_l_age_work_hours * 100), 1);
827: ELSE
828: l_leave_to_work_hour_lower := 0;

Line 831: /* Find the Sick leave for the middle age group, related to the total standard working hours for this group */

827: ELSE
828: l_leave_to_work_hour_lower := 0;
829: END IF;
830:
831: /* Find the Sick leave for the middle age group, related to the total standard working hours for this group */
832: IF l_org_tot_m_age_work_hours > 0 THEN
833: l_leave_to_work_hour_middle := round ((l_org_tot_m_age_sick_hours / l_org_tot_m_age_work_hours * 100), 1);
834: ELSE
835: l_leave_to_work_hour_middle := 0;

Line 838: /* Find the Sick leave for the upper age group, related to the total standard working hours for this group */

834: ELSE
835: l_leave_to_work_hour_middle := 0;
836: END IF;
837:
838: /* Find the Sick leave for the upper age group, related to the total standard working hours for this group */
839: IF l_org_tot_u_age_work_hours > 0 THEN
840: l_leave_to_work_hour_upper := round ((l_org_tot_u_age_sick_hours / l_org_tot_u_age_work_hours * 100), 1);
841: ELSE
842: l_leave_to_work_hour_upper := 0;