How to use Parameter in inline view
569519Sep 14 2008 — edited Sep 15 2008I want to deploye following sql in discoveror. Problem is that how to use the P_TO_DATE in disco.
select papf.employee_number, papf.effective_start_date, papf.effective_end_date, paaf.effective_start_date, paaf.effective_end_date,
(select peev.screen_entry_value
from pay_element_types_f pet,
pay_element_classifications pec,
pay_input_values_f piv,
pay_element_entries_f pee,
pay_element_entry_values_f peev
where pet.classification_id = pec.classification_id
and pet.processing_type = 'R'
and pec.classification_name = 'Earnings'
and piv.name in ('Monthly Amount')
and pet.ELEMENT_TYPE_ID = piv.ELEMENT_TYPE_ID
and pet.element_type_id = pee.element_type_id
and piv.INPUT_VALUE_ID = peev.INPUT_VALUE_ID
and pet.ELEMENT_NAME = 'Basic Salary'
and pee.ELEMENT_ENTRY_ID = peev.ELEMENT_ENTRY_ID
and pee.assignment_id = paaf.assignment_id
and pee.effective_start_date <= :P_TO_DATE and pee.effective_end_date >= :P_TO_DATE
and peev.effective_start_date <= :P_TO_DATE and peev.effective_end_date >= :P_TO_DATE ) Basic_Salary
from per_assignments_f paaf, per_people_f papf
where papf.person_id = paaf.person_id
and papf.employee_number = '101111'