[Home] [Help]
914: TPTYPE.number_per_fiscal_year
915: from
916: pay_payroll_actions PACTION
917: , per_time_periods TPERIOD
918: , per_time_period_types TPTYPE
919: where PACTION.payroll_action_id = p_payroll_action_id
920: and TPERIOD.payroll_id = PACTION.payroll_id
921: and p_date_earned between TPERIOD.start_date and TPERIOD.end_date
922: and TPTYPE.period_type = TPERIOD.period_type;