APPS.PQP_NL_PGGM_FUNCTIONS dependencies on PQP_PENSION_TYPES_F

Line 51: FROM pqp_pension_types_f

47: --Cursor to fetch the min. and max. age specified at the pension type
48: --
49: CURSOR c_get_min_max_ages IS
50: SELECT nvl(minimum_age,0),nvl(maximum_age,100)
51: FROM pqp_pension_types_f
52: WHERE pension_type_id = p_pension_type_id
53: AND p_date_earned BETWEEN effective_start_date
54: AND effective_end_date;
55:

Line 175: FROM pqp_pension_types_f

171: --
172: CURSOR c_get_contrib_frm_pt IS
173: SELECT decode(p_ee_or_total,0,nvl(ee_contribution_percent,0)
174: ,nvl(er_contribution_percent,0))
175: FROM pqp_pension_types_f
176: WHERE pension_type_id = p_pension_type_id
177: AND p_date_earned BETWEEN effective_start_date
178: AND effective_end_date;
179:

Line 513: FROM pqp_pension_types_f

509: --Cursor to fetch the basis method from the pension type
510: --
511: CURSOR c_get_basis_method IS
512: SELECT pension_basis_calc_method
513: FROM pqp_pension_types_f
514: WHERE pension_type_id = p_pension_type_id
515: AND p_date_earned BETWEEN effective_start_date
516: AND effective_end_date;
517:

Line 527: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;

523: l_threshold NUMBER;
524: l_threshold_percentage NUMBER;
525: l_avlb_thld NUMBER := 0;
526: l_used_thld NUMBER := 0;
527: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;
528: l_num_periods NUMBER :=12;
529:
530: BEGIN
531: --hr_utility.trace_on(null,'SS');