[Home] [Help]
1: PACKAGE BODY pqp_pension_functions AS
2: /* $Header: pqppenff.pkb 120.8.12010000.3 2008/10/14 12:55:19 rsahai ship $ */
3:
4: g_ptp_formula_exists BOOLEAN := TRUE;
5: g_ptp_formula_cached BOOLEAN := FALSE;
2420:
2421: --
2422: -- Check if the EE asg was a late hire in the prev year
2423: --
2424: l_py_late_hire_ind := pqp_pension_functions.get_bal_val
2425: (p_business_group_id => p_business_group_id
2426: ,p_assignment_id => p_assignment_id
2427: ,p_effective_date => l_end_of_last_year
2428: ,p_balance_name => 'ABP Late Hire'
2441: ,p_payroll_id => p_payroll_id
2442: ,p_balance_name => 'ABP Average Part Time Percentage'
2443: ,p_dimension_name => 'NL Assignment ABP Year To Date Dimension');
2444: ELSE
2445: l_avg_prev_year_ptp := pqp_pension_functions.get_bal_val
2446: (p_business_group_id => p_business_group_id
2447: ,p_assignment_id => p_assignment_id
2448: ,p_effective_date => l_end_of_last_year
2449: ,p_balance_name => 'ABP Average Part Time Percentage'
2463: ,p_payroll_id => p_payroll_id
2464: ,p_balance_name => 'Retro ABP Part Time Percentage'
2465: ,p_dimension_name => 'NL Assignment ABP Year To Date Dimension');
2466: ELSE
2467: l_retro_avg_ptp := pqp_pension_functions.get_bal_val
2468: (p_business_group_id => p_business_group_id
2469: ,p_assignment_id => p_assignment_id
2470: ,p_effective_date => l_end_of_last_year
2471: ,p_balance_name => 'Retro ABP Part Time Percentage'
2657: ,p_payroll_id => p_payroll_id
2658: ,p_balance_name => 'ABP Full Time Non Recurring Bonus'
2659: ,p_dimension_name => 'NL Assignment ABP Year To Date Dimension');
2660: ELSE
2661: l_ft_non_rec_bonus := pqp_pension_functions.get_bal_val
2662: (p_business_group_id => p_business_group_id
2663: ,p_assignment_id => p_assignment_id
2664: ,p_effective_date => l_end_of_last_year
2665: ,p_balance_name => 'ABP Full Time Non Recurring Bonus'
2678: ,p_payroll_id => p_payroll_id
2679: ,p_balance_name => 'ABP Full Time Non Recurring Bonus For Holiday Allowance'
2680: ,p_dimension_name => 'NL Assignment ABP Year To Date Dimension');
2681: ELSE
2682: l_ft_non_rec_bonus_h := pqp_pension_functions.get_bal_val
2683: (p_business_group_id => p_business_group_id
2684: ,p_assignment_id => p_assignment_id
2685: ,p_effective_date => l_end_of_last_year
2686: ,p_balance_name => 'ABP Full Time Non Recurring Bonus For Holiday Allowance'
2699: ,p_payroll_id => p_payroll_id
2700: ,p_balance_name => 'ABP Part Time Non Recurring Bonus'
2701: ,p_dimension_name => 'NL Assignment ABP Year To Date Dimension');
2702: ELSE
2703: l_pt_non_rec_bonus := pqp_pension_functions.get_bal_val
2704: (p_business_group_id => p_business_group_id
2705: ,p_assignment_id => p_assignment_id
2706: ,p_effective_date => l_end_of_last_year
2707: ,p_balance_name => 'ABP Part Time Non Recurring Bonus'
2727: ,p_payroll_id => p_payroll_id
2728: ,p_balance_name => 'ABP Part Time Non Recurring Bonus For Holiday Allowance'
2729: ,p_dimension_name => 'NL Assignment ABP Year To Date Dimension');
2730: ELSE
2731: l_pt_non_rec_bonus_h := pqp_pension_functions.get_bal_val
2732: (p_business_group_id => p_business_group_id
2733: ,p_assignment_id => p_assignment_id
2734: ,p_effective_date => l_end_of_last_year
2735: ,p_balance_name => 'ABP Part Time Non Recurring Bonus For Holiday Allowance'
2958: ,p_payroll_id => p_payroll_id
2959: ,p_balance_name => 'ABP Pension Salary'
2960: ,p_dimension_name => 'NL Assignment ABP Year To Date Dimension');
2961: ELSE
2962: l_pension_sal_prev_yr := pqp_pension_functions.get_bal_val
2963: (p_business_group_id => p_business_group_id
2964: ,p_assignment_id => p_assignment_id
2965: ,p_effective_date => l_end_of_last_year
2966: ,p_balance_name => 'ABP Pension Salary'
5160:
5161: --
5162: -- Check if there is an override in the HOOK for the ABP Part time percent
5163: --
5164: l_hook_ptp := pqp_pension_functions.get_hook_part_time_perc (p_assignment_id
5165: ,p_date_earned
5166: ,p_business_group_id
5167: ,p_assignment_action_id);
5168:
5454: RETURN 0;
5455:
5456: END get_pay_period_age;
5457:
5458: end pqp_pension_functions;