1472: FROM per_time_periods ptp, per_time_period_types ptpt
1473: WHERE p_ptp_id = ptp.time_period_id
1474: AND ptp.period_type = ptpt.period_type;
1475:
1476: v_proposed_salary per_pay_proposals_v.proposed_salary%TYPE;
1477: v_pay_basis per_pay_proposals_v.pay_basis%TYPE;
1478: l_hours_per_year NUMBER (22, 5)
1479: := TO_NUMBER (fnd_profile.VALUE ('HXT_HOURS_PER_YEAR'));
1480: v_annual_pay_periods per_time_period_types.number_per_fiscal_year%TYPE;
1473: WHERE p_ptp_id = ptp.time_period_id
1474: AND ptp.period_type = ptpt.period_type;
1475:
1476: v_proposed_salary per_pay_proposals_v.proposed_salary%TYPE;
1477: v_pay_basis per_pay_proposals_v.pay_basis%TYPE;
1478: l_hours_per_year NUMBER (22, 5)
1479: := TO_NUMBER (fnd_profile.VALUE ('HXT_HOURS_PER_YEAR'));
1480: v_annual_pay_periods per_time_period_types.number_per_fiscal_year%TYPE;
1481: BEGIN