[Home] [Help]
14:
15: -- Bug 13705204
16: -- Defined the datatype and added a global variable here.
17: CURSOR csr_iv_info_m (
18: p_element_type_id pay_element_types_f.element_type_id%TYPE,
19: p_iv_number PLS_INTEGER,
20: p_session_date DATE
21: )
22: IS
24: FROM (SELECT iv_data.*, ROWNUM r
25: FROM (SELECT inv.uom, inv.lookup_type, inv.value_set_id,
26: etp.input_currency_code
27: FROM pay_input_values_f inv,
28: pay_element_types_f etp
29: WHERE inv.element_type_id = p_element_type_id
30: AND etp.element_type_id = p_element_type_id
31: AND p_session_date
32: BETWEEN inv.effective_start_date
86: || (p_iv_number) Input Value of an Element Type without having to loop over
87: || all of them and then stop at the nth position.
88: */
89: CURSOR csr_iv_info (
90: p_element_type_id pay_element_types_f.element_type_id%TYPE,
91: p_iv_number PLS_INTEGER,
92: p_session_date DATE
93: )
94: IS
96: FROM (SELECT iv_data.*, ROWNUM r
97: FROM (SELECT inv.uom, inv.lookup_type, inv.value_set_id,
98: etp.input_currency_code
99: FROM pay_input_values_f inv,
100: pay_element_types_f etp
101: WHERE inv.element_type_id = p_element_type_id
102: AND etp.element_type_id = p_element_type_id
103: AND p_session_date
104: BETWEEN inv.effective_start_date
895: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
896: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
897: p_det_tbb_idx IN PLS_INTEGER,
898: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
899: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
900: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,
901: p_bee_rec IN OUT NOCOPY hxt_interface_utilities.bee_rec,
902: p_is_old IN BOOLEAN DEFAULT FALSE
903: )