[Home] [Help]
1: PACKAGE BODY pqp_pension_functions AS
2: /* $Header: pqppenff.pkb 120.13.12020000.2 2012/08/16 07:38:36 asudhaka ship $ */
3:
4: g_ptp_formula_exists BOOLEAN := TRUE;
5: g_ptp_formula_cached BOOLEAN := FALSE;
2495:
2496: --
2497: -- Check if the EE asg was a late hire in the prev year
2498: --
2499: l_py_late_hire_ind := pqp_pension_functions.get_bal_val
2500: (p_business_group_id => p_business_group_id
2501: ,p_assignment_id => p_assignment_id
2502: ,p_effective_date => l_end_of_last_year
2503: ,p_balance_name => 'ABP Late Hire'
2516: ,p_payroll_id => p_payroll_id
2517: ,p_balance_name => 'ABP Average Part Time Percentage'
2518: ,p_dimension_name => 'NL Assignment ABP Year To Date Dimension');
2519: ELSE
2520: l_avg_prev_year_ptp := pqp_pension_functions.get_bal_val
2521: (p_business_group_id => p_business_group_id
2522: ,p_assignment_id => p_assignment_id
2523: ,p_effective_date => l_end_of_last_year
2524: ,p_balance_name => 'ABP Average Part Time Percentage'
2538: ,p_payroll_id => p_payroll_id
2539: ,p_balance_name => 'Retro ABP Part Time Percentage'
2540: ,p_dimension_name => 'NL Assignment ABP Year To Date Dimension');
2541: ELSE
2542: l_retro_avg_ptp := pqp_pension_functions.get_bal_val
2543: (p_business_group_id => p_business_group_id
2544: ,p_assignment_id => p_assignment_id
2545: ,p_effective_date => l_end_of_last_year
2546: ,p_balance_name => 'Retro ABP Part Time Percentage'
2732: ,p_payroll_id => p_payroll_id
2733: ,p_balance_name => 'ABP Full Time Non Recurring Bonus'
2734: ,p_dimension_name => 'NL Assignment ABP Year To Date Dimension');
2735: ELSE
2736: l_ft_non_rec_bonus := pqp_pension_functions.get_bal_val
2737: (p_business_group_id => p_business_group_id
2738: ,p_assignment_id => p_assignment_id
2739: ,p_effective_date => l_end_of_last_year
2740: ,p_balance_name => 'ABP Full Time Non Recurring Bonus'
2753: ,p_payroll_id => p_payroll_id
2754: ,p_balance_name => 'ABP Full Time Non Recurring Bonus For Holiday Allowance'
2755: ,p_dimension_name => 'NL Assignment ABP Year To Date Dimension');
2756: ELSE
2757: l_ft_non_rec_bonus_h := pqp_pension_functions.get_bal_val
2758: (p_business_group_id => p_business_group_id
2759: ,p_assignment_id => p_assignment_id
2760: ,p_effective_date => l_end_of_last_year
2761: ,p_balance_name => 'ABP Full Time Non Recurring Bonus For Holiday Allowance'
2774: ,p_payroll_id => p_payroll_id
2775: ,p_balance_name => 'ABP Part Time Non Recurring Bonus'
2776: ,p_dimension_name => 'NL Assignment ABP Year To Date Dimension');
2777: ELSE
2778: l_pt_non_rec_bonus := pqp_pension_functions.get_bal_val
2779: (p_business_group_id => p_business_group_id
2780: ,p_assignment_id => p_assignment_id
2781: ,p_effective_date => l_end_of_last_year
2782: ,p_balance_name => 'ABP Part Time Non Recurring Bonus'
2802: ,p_payroll_id => p_payroll_id
2803: ,p_balance_name => 'ABP Part Time Non Recurring Bonus For Holiday Allowance'
2804: ,p_dimension_name => 'NL Assignment ABP Year To Date Dimension');
2805: ELSE
2806: l_pt_non_rec_bonus_h := pqp_pension_functions.get_bal_val
2807: (p_business_group_id => p_business_group_id
2808: ,p_assignment_id => p_assignment_id
2809: ,p_effective_date => l_end_of_last_year
2810: ,p_balance_name => 'ABP Part Time Non Recurring Bonus For Holiday Allowance'
3055: ,p_payroll_id => p_payroll_id
3056: ,p_balance_name => 'ABP Pension Salary'
3057: ,p_dimension_name => 'NL Assignment ABP Year To Date Dimension');
3058: ELSE
3059: l_pension_sal_prev_yr := pqp_pension_functions.get_bal_val
3060: (p_business_group_id => p_business_group_id
3061: ,p_assignment_id => p_assignment_id
3062: ,p_effective_date => l_end_of_last_year
3063: ,p_balance_name => 'ABP Pension Salary'
5257:
5258: --
5259: -- Check if there is an override in the HOOK for the ABP Part time percent
5260: --
5261: l_hook_ptp := pqp_pension_functions.get_hook_part_time_perc (p_assignment_id
5262: ,p_date_earned
5263: ,p_business_group_id
5264: ,p_assignment_action_id);
5265:
5551: RETURN 0;
5552:
5553: END get_pay_period_age;
5554:
5555: end pqp_pension_functions;