DBA Data[Home] [Help]

APPS.PER_HU_PENSION_OBJECTS dependencies on PQP_PENSION_TYPES_F

Line 119: FROM pqp_pension_types_f

115:
116: CURSOR cur_get_pt_details IS
117: SELECT decode(p_ee_element,'Y',nvl(ee_contribution_percent,0),nvl(er_contribution_percent,0))
118: ,decode(p_ee_element,'Y',nvl(ee_contribution_fixed_rate,0),nvl(er_contribution_fixed_rate,0))
119: FROM pqp_pension_types_f
120: WHERE pension_type_id = p_pension_type
121: AND p_effective_start_date BETWEEN effective_start_date
122: AND effective_end_date;
123: