[Home] [Help]
1650: -- |-------------------< retrieve_element_entry_value >----------------------|
1651: -- ---------------------------------------------------------------------------
1652: --
1653: procedure retrieve_element_entry_value
1654: (p_element_name in pay_element_types_f.element_name%type
1655: ,p_input_value_name in pay_input_values_f.name%type
1656: ,p_assignment_id in pay_element_entries_f.assignment_id%type
1657: ,p_effective_date in date
1658: ,p_value OUT NOCOPY varchar2
1659: ,p_multiple_error_flag OUT NOCOPY boolean
1660: ) is
1661: --
1662: l_proc varchar2(72) := g_package||'retrieve_element_entry_value';
1663: l_processing_type pay_element_types_f.processing_type%type;
1664: l_ele_proc_type_found boolean := FALSE;
1665: l_rec_ele_ent_val_found boolean := FALSE;
1666: l_nonrec_ele_ent_val_found boolean := FALSE;
1667: l_session ghr_history_api.g_session_var_type;
1670: ,eff_date in date
1671: ,bg_id in number
1672: ) is
1673: select elt.processing_type
1674: from pay_element_types_f elt
1675: where trunc(eff_date) between elt.effective_start_date
1676: and elt.effective_end_date
1677: and upper(elt.element_name) = upper(ele_name)
1678: --Ashley
1683: ,asg_id in number
1684: ,eff_date in date
1685: ,bg_id in number) is
1686: select eev.screen_entry_value screen_entry_value
1687: from pay_element_types_f elt,
1688: pay_input_values_f ipv,
1689: pay_element_entries_f ele,
1690: pay_element_entry_values_f eev
1691: where trunc(eff_date) between elt.effective_start_date
1710: ,asg_id in number
1711: ,eff_date in date
1712: ,bg_id in number) is
1713: select eev.screen_entry_value screen_entry_value
1714: from pay_element_types_f elt,
1715: pay_input_values_f ipv,
1716: pay_element_entries_f ele,
1717: pay_element_entry_values_f eev
1718: where trunc(eff_date) between elt.effective_start_date