eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_PENSION_FUNCTIONS dependencies on PQP_PENSION_TYPES_F

Line 34: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE

30: -- |---------------------< get_pension_type_details >--------------------------|
31: -- ----------------------------------------------------------------------------
32: --
33: FUNCTION get_pension_type_details
34: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
35: ,p_date_earned IN DATE
36: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
37: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
38: ,p_legislation_code IN pqp_pension_types_f.legislation_code%TYPE

Line 37: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE

33: FUNCTION get_pension_type_details
34: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
35: ,p_date_earned IN DATE
36: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
37: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
38: ,p_legislation_code IN pqp_pension_types_f.legislation_code%TYPE
39: ,p_column_name IN VARCHAR2
40: ,p_column_value OUT NOCOPY VARCHAR2
41: ,p_error_message OUT NOCOPY VARCHAR2

Line 38: ,p_legislation_code IN pqp_pension_types_f.legislation_code%TYPE

34: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
35: ,p_date_earned IN DATE
36: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
37: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
38: ,p_legislation_code IN pqp_pension_types_f.legislation_code%TYPE
39: ,p_column_name IN VARCHAR2
40: ,p_column_value OUT NOCOPY VARCHAR2
41: ,p_error_message OUT NOCOPY VARCHAR2
42: ) RETURN NUMBER IS

Line 48: FROM pqp_pension_types_f

44: CURSOR c_pty_cur (c_business_group_id IN NUMBER
45: ,c_pension_type_id IN NUMBER
46: ,c_date_earned IN DATE) IS
47: SELECT *
48: FROM pqp_pension_types_f
49: WHERE c_date_earned BETWEEN effective_start_date
50: AND effective_end_date
51: AND business_group_id = c_business_group_id
52: AND pension_type_id = c_pension_type_id;

Line 71: FROM pqp_pension_types_f

67: AND paa.assignment_id = p_assignment_id;
68:
69: CURSOR c_get_ee_age_threshold(c_pension_type_id IN NUMBER) IS
70: SELECT NVL(EE_AGE_THRESHOLD,'N')
71: FROM pqp_pension_types_f
72: WHERE pension_type_id = c_pension_type_id
73: AND p_date_earned between effective_start_date and effective_end_date;
74:
75: CURSOR c_get_er_age_threshold(c_pension_type_id IN NUMBER) IS

Line 77: FROM pqp_pension_types_f

73: AND p_date_earned between effective_start_date and effective_end_date;
74:
75: CURSOR c_get_er_age_threshold(c_pension_type_id IN NUMBER) IS
76: SELECT NVL(ER_AGE_THRESHOLD,'N')
77: FROM pqp_pension_types_f
78: WHERE pension_type_id = c_pension_type_id
79: AND p_date_earned between effective_start_date and effective_end_date;
80:
81:

Line 84: l_pension_id pqp_pension_types_f.pension_type_id%TYPE;

80:
81:
82:
83: l_proc_name VARCHAR2(150) := g_proc_name || 'get_pension_type_details';
84: l_pension_id pqp_pension_types_f.pension_type_id%TYPE;
85: l_subcat VARCHAR2(80);
86: l_pension_rec c_pty_cur%ROWTYPE;
87: l_ee_age_threshold pqp_pension_types_f.ee_age_threshold%TYPE;
88: l_person_year_of_birth VARCHAR2(10);

Line 87: l_ee_age_threshold pqp_pension_types_f.ee_age_threshold%TYPE;

83: l_proc_name VARCHAR2(150) := g_proc_name || 'get_pension_type_details';
84: l_pension_id pqp_pension_types_f.pension_type_id%TYPE;
85: l_subcat VARCHAR2(80);
86: l_pension_rec c_pty_cur%ROWTYPE;
87: l_ee_age_threshold pqp_pension_types_f.ee_age_threshold%TYPE;
88: l_person_year_of_birth VARCHAR2(10);
89: l_er_age_threshold pqp_pension_types_f.er_age_threshold%TYPE;
90:
91: BEGIN

Line 89: l_er_age_threshold pqp_pension_types_f.er_age_threshold%TYPE;

85: l_subcat VARCHAR2(80);
86: l_pension_rec c_pty_cur%ROWTYPE;
87: l_ee_age_threshold pqp_pension_types_f.ee_age_threshold%TYPE;
88: l_person_year_of_birth VARCHAR2(10);
89: l_er_age_threshold pqp_pension_types_f.er_age_threshold%TYPE;
90:
91: BEGIN
92:
93: hr_utility.set_location('Entering : '||l_proc_name, 10);

Line 437: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

433: -- |-------------------------< prorate_amount >-------------------------------|
434: -- ----------------------------------------------------------------------------
435: --
436: function prorate_amount
437: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
438: ,p_date_earned in date
439: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
440: ,p_amount in number
441: ,p_payroll_period in varchar2

Line 1865: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE

1861: -- is processed eff jan 2007. Do not use this function in any other
1862: -- situation other than ABP late hires.
1863: --
1864: FUNCTION get_bal_val_de
1865: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
1866: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1867: ,p_date_earned IN DATE
1868: ,p_start_date IN DATE
1869: ,p_end_date IN DATE

Line 1946: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE

1942: -- ----------------------------------------------------------------------------
1943: -- |-----------------------------< get_bal_val >-------------------------------|
1944: -- ----------------------------------------------------------------------------
1945: FUNCTION get_bal_val
1946: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
1947: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1948: ,p_effective_date IN DATE
1949: ,p_balance_name IN VARCHAR2
1950: ,p_dimension_name IN VARCHAR2)

Line 1995: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

1991: -- ----------------------------------------------------------------------------
1992: -- |-----------------------< get_abp_pension_salary >-----------------------------|
1993: -- ----------------------------------------------------------------------------
1994: function get_abp_pension_salary
1995: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
1996: ,p_date_earned in date
1997: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1998: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
1999: ,p_period_start_date in date

Line 3033: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

3029: -- |-----------------------< get_pension_salary >-----------------------------|
3030: -- ----------------------------------------------------------------------------
3031: --
3032: function get_pension_salary
3033: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
3034: ,p_date_earned in date
3035: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3036: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
3037: ,p_salary_balance_name in varchar2

Line 3041: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE default -99

3037: ,p_salary_balance_name in varchar2
3038: ,p_payroll_period in varchar2
3039: ,p_salary_balance_value out nocopy number
3040: ,p_error_message out nocopy varchar2
3041: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE default -99
3042: ) return number is
3043:
3044: l_proc_name varchar2(150) := g_proc_name || 'get_pension_salary';
3045: l_hire_date date;

Line 3125: FROM pqp_pension_types_f

3121:
3122: --Cursor to check if the pension type is an ABP Pension Type
3123: CURSOR c_is_abp_pt IS
3124: SELECT 1
3125: FROM pqp_pension_types_f
3126: WHERE pension_type_id = p_pension_type_id
3127: AND special_pension_type_code = 'ABP';
3128:
3129: BEGIN

Line 3326: pqp_pension_types_f pty

3322: --Cursor to find if the pension type is assigned to this org
3323: CURSOR c_is_pen_type_assigned(c_org_id in number) Is
3324: SELECT 1
3325: FROM hr_organization_information hoi,
3326: pqp_pension_types_f pty
3327: WHERE hoi.org_information_context = 'PQP_NL_ER_PENSION_TYPES'
3328: AND hoi.org_information2 = TO_CHAR(p_pension_type_id)
3329: AND hoi.organization_id = c_org_id
3330: AND pty.pension_type_id = p_pension_type_id

Line 3340: FROM pqp_pension_types_f

3336: );
3337: --Cursor to find the pension type name from the pension type id
3338: CURSOR c_find_pen_type_name Is
3339: SELECT pension_type_name
3340: FROM pqp_pension_types_f
3341: WHERE pension_type_id = p_pension_type_id
3342: AND rownum = 1;
3343:
3344: --Cursor to find if the pension type is valid as of the date earned

Line 3347: FROM pqp_pension_types_f

3343:
3344: --Cursor to find if the pension type is valid as of the date earned
3345: CURSOR c_find_pen_type_valid Is
3346: SELECT 1
3347: FROM pqp_pension_types_f
3348: WHERE pension_type_id = p_pension_type_id
3349: AND trunc(p_date_earned) between effective_start_date and effective_end_date
3350: AND business_group_id = p_business_group_id;
3351:

Line 3788: FROM pqp_pension_types_f

3784: nvl(SIG_SAL_STD_TAX_REDUCTION,'0')||
3785: nvl(SII_STD_TAX_REDUCTION,'0')||
3786: nvl(SII_SPL_TAX_REDUCTION,'0')||
3787: nvl(SII_NON_TAX_REDUCTION,'0') redstr
3788: FROM pqp_pension_types_f
3789: WHERE pension_type_id = p_pension_type_id
3790: AND trunc(p_effective_date) BETWEEN
3791: trunc(effective_start_date)
3792: AND trunc(effective_end_date);

Line 4141: FROM pqp_pension_types_f

4137: nvl(SIG_SAL_STD_TAX_REDUCTION,'0')||
4138: nvl(SII_STD_TAX_REDUCTION,'0')||
4139: nvl(SII_SPL_TAX_REDUCTION,'0')||
4140: nvl(SII_NON_TAX_REDUCTION,'0') redstr
4141: FROM pqp_pension_types_f
4142: WHERE pension_type_id = p_pension_type_id
4143: AND trunc(p_effective_date) BETWEEN
4144: trunc(effective_start_date)
4145: AND trunc(effective_end_date);

Line 4420: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

4416: -- ------------------------------------------------------------------
4417: FUNCTION get_bonus
4418: ( p_date_earned in date
4419: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4420: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
4421: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
4422: ,p_pay_period_salary in number
4423: ,p_pay_period in varchar2
4424: ,p_work_pattern in varchar2

Line 4421: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE

4417: FUNCTION get_bonus
4418: ( p_date_earned in date
4419: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4420: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
4421: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
4422: ,p_pay_period_salary in number
4423: ,p_pay_period in varchar2
4424: ,p_work_pattern in varchar2
4425: ,p_conversion_rule in varchar2

Line 4444: l_recur_bonus_period pqp_pension_types_f.recurring_bonus_period%type;

4440: l_recur_bonus number := 0;
4441: l_non_recur_bonus number := 0;
4442: l_prev_recur_bonus number := 0;
4443: l_prev_non_recur_bonus number := 0;
4444: l_recur_bonus_period pqp_pension_types_f.recurring_bonus_period%type;
4445: l_non_recur_bonus_period pqp_pension_types_f.non_recurring_bonus_period%type;
4446: l_end_of_prev_yr date;
4447: l_prev_run_year number;
4448: l_payroll_id pay_payrolls_f.payroll_id%type;

Line 4445: l_non_recur_bonus_period pqp_pension_types_f.non_recurring_bonus_period%type;

4441: l_non_recur_bonus number := 0;
4442: l_prev_recur_bonus number := 0;
4443: l_prev_non_recur_bonus number := 0;
4444: l_recur_bonus_period pqp_pension_types_f.recurring_bonus_period%type;
4445: l_non_recur_bonus_period pqp_pension_types_f.non_recurring_bonus_period%type;
4446: l_end_of_prev_yr date;
4447: l_prev_run_year number;
4448: l_payroll_id pay_payrolls_f.payroll_id%type;
4449: l_asg_action_id pay_assignment_actions.assignment_action_id%type;

Line 4465: FROM pqp_pension_types_f

4461: ,non_recurring_bonus_balance
4462: ,previous_year_bonus_included
4463: ,recurring_bonus_period
4464: ,non_recurring_bonus_period
4465: FROM pqp_pension_types_f
4466: WHERE pension_type_id = p_pension_type_id
4467: AND TRUNC(p_date_earned) BETWEEN
4468: effective_start_date AND effective_end_date
4469: AND business_group_id = p_business_group_id;

Line 4785: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

4781: -- -----------------------------------------------------------------------
4782: -- |---------------------< get_abp_entry_value >--------------------------|
4783: -- -----------------------------------------------------------------------
4784: function get_abp_entry_value
4785: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
4786: ,p_date_earned in date
4787: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4788: ,p_element_type_id in number
4789: ,p_input_value_name in varchar2

Line 5101: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

5097: -- This function is to get the average part time percentage of the
5098: -- employee for calculations in pension basis.
5099:
5100: function get_avg_part_time_perc
5101: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
5102: ,p_date_earned in date
5103: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5104: ,p_assignment_action_id IN NUMBER
5105: ,p_period_start_date in DATE

Line 5369: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE

5365: -- |---------------------< get_pay_period_age >-------------------------------|
5366: -- ----------------------------------------------------------------------------
5367: --
5368: FUNCTION get_pay_period_age
5369: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
5370: ,p_date_earned IN DATE
5371: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
5372: ,p_period_start_date IN DATE
5373: ) RETURN NUMBER IS