261: pev.SCREEN_ENTRY_VALUE,
262: pee.element_entry_id
263: from pay_accrual_plans pap,
264: pay_element_entry_values_f pev,
265: pay_element_entries_f pee,
266: pay_element_links_f pel,
267: pay_element_types_f pet,
268: pay_input_values_f piv
269: where ( pap.accrual_plan_id = p_plan_id OR
703: --
704: hr_utility.set_location('get_accrual',65);
705: select min(effective_start_date)
706: into l_plan_start_date
707: from pay_element_entries_f
708: where element_entry_id = l_element_entry_id;
709: hr_utility.set_location('get_accrual',67);
710: ---
711: