[Home] [Help]
4419: a.effective_start_date, a.effective_end_date
4420: from PSB_PAY_ELEMENT_DISTRIBUTIONS a,
4421: PSB_ELEMENT_POS_SET_GROUPS b,
4422: PSB_SET_RELATIONS c,
4423: PSB_BUDGET_POSITIONS d
4424: where a.chart_of_accounts_id = p_flex_code
4425: and (((a.effective_start_date <= p_end_date)
4426: and (a.effective_end_date is null))
4427: or ((a.effective_start_date between p_start_date and p_end_date)