[Home] [Help]
82: BEGIN
83:
84: select count(*)
85: into x_dummy
86: from pa_expenditure_types_expend_v
87: where x_ei_date between expnd_typ_start_date_active
88: and nvl(expnd_typ_end_date_active,x_ei_date)
89: and x_ei_date between SYS_LINK_START_DATE_ACTIVE
90: and nvl(sys_link_end_date_active,x_ei_date)