1: PACKAGE BODY PAY_NO_ABSENCE AS
2: /* $Header: pynoabsence.pkb 120.1 2007/07/10 05:38:01 pdavidra noship $ */
3: Function CALCULATE_PAYMENT
4: ( p_assignment_id IN NUMBER
5: ,p_effective_date IN DATE
2633: p_ear_value := nvl(p_ear_value,0);
2634:
2635: -- To get slab values for child minder sickness.
2636: -- One child with less than 13 years of age.
2637: l_child_1_13 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,
2638: 'NO_CHILDMINDER_SICK_DURATION','Duration','A');
2639:
2640:
2641: -- Two children with less than 13 years of age.
2638: 'NO_CHILDMINDER_SICK_DURATION','Duration','A');
2639:
2640:
2641: -- Two children with less than 13 years of age.
2642: l_child_2_13 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,
2643: 'NO_CHILDMINDER_SICK_DURATION','Duration','B');
2644:
2645:
2646: -- More than One child with less than 19 years of age.
2643: 'NO_CHILDMINDER_SICK_DURATION','Duration','B');
2644:
2645:
2646: -- More than One child with less than 19 years of age.
2647: l_child_1_19 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,
2648: 'NO_CHILDMINDER_SICK_DURATION','Duration','C');
2649:
2650:
2651: -- One Sole Guardian child with less than 13 years of age.
2648: 'NO_CHILDMINDER_SICK_DURATION','Duration','C');
2649:
2650:
2651: -- One Sole Guardian child with less than 13 years of age.
2652: l_childsg_1_13 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,
2653: 'NO_CHILDMINDER_SICK_DURATION','Duration','A_SG');
2654:
2655:
2656: -- Two Sole Guardian children with less than 13 years of age.
2653: 'NO_CHILDMINDER_SICK_DURATION','Duration','A_SG');
2654:
2655:
2656: -- Two Sole Guardian children with less than 13 years of age.
2657: l_childsg_2_13 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,
2658: 'NO_CHILDMINDER_SICK_DURATION','Duration','B_SG');
2659:
2660:
2661: -- More than One Sole Guardian child with less than 19 years of age.
2658: 'NO_CHILDMINDER_SICK_DURATION','Duration','B_SG');
2659:
2660:
2661: -- More than One Sole Guardian child with less than 19 years of age.
2662: l_childsg_1_19 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,
2663: 'NO_CHILDMINDER_SICK_DURATION','Duration','C_SG');
2664:
2665:
2666: -- Calculate total absence days
7886:
7887: END get_abs_st_date;
7888:
7889:
7890: END PAY_NO_ABSENCE;