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.2.12020000.11 2013/02/19 09:27:29 dakhuran ship $ */
3: Function CALCULATE_PAYMENT
4: ( p_assignment_id IN NUMBER
5: ,p_effective_date IN DATE

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

2677: p_ear_value := nvl(p_ear_value,0);
2678:
2679: -- To get slab values for child minder sickness.
2680: -- One child with less than 13 years of age.
2681: l_child_1_13 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,
2682: 'NO_CHILDMINDER_SICK_DURATION','Duration','A');
2683:
2684:
2685: -- Two children with less than 13 years of age.

Line 2686: l_child_2_13 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,

2682: 'NO_CHILDMINDER_SICK_DURATION','Duration','A');
2683:
2684:
2685: -- Two children with less than 13 years of age.
2686: l_child_2_13 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,
2687: 'NO_CHILDMINDER_SICK_DURATION','Duration','B');
2688:
2689:
2690: -- More than One child with less than 19 years of age.

Line 2691: l_child_1_19 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,

2687: 'NO_CHILDMINDER_SICK_DURATION','Duration','B');
2688:
2689:
2690: -- More than One child with less than 19 years of age.
2691: l_child_1_19 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,
2692: 'NO_CHILDMINDER_SICK_DURATION','Duration','C');
2693:
2694:
2695: -- One Sole Guardian child with less than 13 years of age.

Line 2696: l_childsg_1_13 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,

2692: 'NO_CHILDMINDER_SICK_DURATION','Duration','C');
2693:
2694:
2695: -- One Sole Guardian child with less than 13 years of age.
2696: l_childsg_1_13 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,
2697: 'NO_CHILDMINDER_SICK_DURATION','Duration','A_SG');
2698:
2699:
2700: -- Two Sole Guardian children with less than 13 years of age.

Line 2701: l_childsg_2_13 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,

2697: 'NO_CHILDMINDER_SICK_DURATION','Duration','A_SG');
2698:
2699:
2700: -- Two Sole Guardian children with less than 13 years of age.
2701: l_childsg_2_13 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,
2702: 'NO_CHILDMINDER_SICK_DURATION','Duration','B_SG');
2703:
2704:
2705: -- More than One Sole Guardian child with less than 19 years of age.

Line 2706: l_childsg_1_19 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,

2702: 'NO_CHILDMINDER_SICK_DURATION','Duration','B_SG');
2703:
2704:
2705: -- More than One Sole Guardian child with less than 19 years of age.
2706: l_childsg_1_19 := PAY_NO_ABSENCE.GET_USERTABLE (p_effective_date, p_business_group_id,
2707: 'NO_CHILDMINDER_SICK_DURATION','Duration','C_SG');
2708:
2709:
2710: -- Calculate total absence days

Line 8057: END PAY_NO_ABSENCE;

8053: WHEN OTHERS THEN
8054: RETURN L_COUNT;
8055: END GET_COUNT_DAILY_RATE;
8056:
8057: END PAY_NO_ABSENCE;