1826: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
1827: Select ele.element_entry_id
1828: from per_pay_bases bas,
1829: pay_element_entries_f ele,
1830: pay_element_entry_values_f entval
1831: where bas.pay_basis_id = P_pay_basis_id
1832: and entval.input_value_id = bas.input_value_id
1833: and p_effective_date
1834: between entval.effective_start_date
3414: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
3415: Select ele.element_entry_id
3416: from per_pay_bases bas,
3417: pay_element_entries_f ele,
3418: pay_element_entry_values_f entval
3419: where bas.pay_basis_id = P_pay_basis_id
3420: and entval.input_value_id = bas.input_value_id
3421: and p_effective_date
3422: between entval.effective_start_date