686: FROM per_time_periods ptp, per_time_period_types ptpt
687: WHERE p_ptp_id = ptp.time_period_id
688: AND ptp.period_type = ptpt.period_type;
689:
690: v_proposed_salary per_pay_proposals_v.proposed_salary%TYPE;
691: v_pay_basis per_pay_proposals_v.pay_basis%TYPE;
692: l_hours_per_year NUMBER (22, 5)
693: := TO_NUMBER (fnd_profile.VALUE ('HXT_HOURS_PER_YEAR'));
694: v_annual_pay_periods per_time_period_types.number_per_fiscal_year%TYPE;
687: WHERE p_ptp_id = ptp.time_period_id
688: AND ptp.period_type = ptpt.period_type;
689:
690: v_proposed_salary per_pay_proposals_v.proposed_salary%TYPE;
691: v_pay_basis per_pay_proposals_v.pay_basis%TYPE;
692: l_hours_per_year NUMBER (22, 5)
693: := TO_NUMBER (fnd_profile.VALUE ('HXT_HOURS_PER_YEAR'));
694: v_annual_pay_periods per_time_period_types.number_per_fiscal_year%TYPE;
695: BEGIN