APPS.PAY_IE_PENSIONS dependencies on PQP_PENSION_TYPES_F

Line 70: FROM pqp_pension_types_f

66: l_percent := 0;
67: IF p_contribution_type='EE' THEN
68: SELECT ee_contribution_percent, ee_annual_contribution
69: INTO l_percent, l_amount
70: FROM pqp_pension_types_f
71: WHERE pension_type_id = p_pension_type_id
72: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
73: IF l_amount = 0 or l_amount is null THEN
74: l_amount := p_pensionable_pay*nvl(l_percent,0)/100;

Line 79: FROM pqp_pension_types_f

75: END IF;
76: ELSE
77: SELECT er_contribution_percent, er_annual_contribution
78: INTO l_percent, l_amount
79: FROM pqp_pension_types_f
80: WHERE pension_type_id = p_pension_type_id
81: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
82: IF l_amount = 0 or l_amount is null THEN
83: l_amount := p_pensionable_pay*nvl(l_percent,0)/100;