APPS.HXT_TD_UTIL dependencies on PER_TIME_PERIOD_TYPES

Line 686: FROM per_time_periods ptp, per_time_period_types ptpt

682:
683: CURSOR num_periods_cur
684: IS
685: SELECT ptpt.number_per_fiscal_year
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;

Line 694: v_annual_pay_periods per_time_period_types.number_per_fiscal_year%TYPE;

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
696: OPEN sal_cur;
697: FETCH sal_cur INTO v_proposed_salary, v_pay_basis;
698: