DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE dependencies on PAY_NO_ABSENCE

Line 1: PACKAGE BODY PAY_NO_ABSENCE AS

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

Line 2637: l_child_1_13 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,

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.

Line 2642: l_child_2_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.
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.

Line 2647: l_child_1_19 := 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.
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.

Line 2652: l_childsg_1_13 := 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.
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.

Line 2657: l_childsg_2_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.
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.

Line 2662: l_childsg_1_19 := 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.
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

Line 7890: END PAY_NO_ABSENCE;

7886:
7887: END get_abs_st_date;
7888:
7889:
7890: END PAY_NO_ABSENCE;