APPS.PQP_NL_PGGM_FUNCTIONS dependencies on PQP_PENSION_TYPES_F

Line 63: FROM pqp_pension_types_f

59: --Cursor to fetch the min. and max. age specified at the pension type
60: --
61: CURSOR c_get_min_max_ages IS
62: SELECT nvl(minimum_age,0),nvl(maximum_age,100)
63: FROM pqp_pension_types_f
64: WHERE pension_type_id = p_pension_type_id
65: AND p_date_earned BETWEEN effective_start_date
66: AND effective_end_date;
67:

Line 187: FROM pqp_pension_types_f

183: --
184: CURSOR c_get_contrib_frm_pt IS
185: SELECT decode(p_ee_or_total,0,nvl(ee_contribution_percent,0)
186: ,nvl(er_contribution_percent,0))
187: FROM pqp_pension_types_f
188: WHERE pension_type_id = p_pension_type_id
189: AND p_date_earned BETWEEN effective_start_date
190: AND effective_end_date;
191:

Line 628: FROM pqp_pension_types_f

624: --Cursor to fetch the basis method from the pension type
625: --
626: CURSOR c_get_basis_method IS
627: SELECT pension_basis_calc_method
628: FROM pqp_pension_types_f
629: WHERE pension_type_id = p_pension_type_id
630: AND p_date_earned BETWEEN effective_start_date
631: AND effective_end_date;
632:

Line 642: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;

638: l_threshold NUMBER;
639: l_threshold_percentage NUMBER;
640: l_avlb_thld NUMBER := 0;
641: l_used_thld NUMBER := 0;
642: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;
643: l_num_periods NUMBER :=12;
644:
645: BEGIN
646: --hr_utility.trace_on(null,'SS');