eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_BATCH_ELEMENT_ENTRY_API dependencies on PAY_INPUT_VALUES_F

Line 164: from pay_input_values_f inv

160: --
161: cursor csr_table_inp_ids(p_ele_type_id number
162: ,p_eff_date date) is
163: select inv.uom,inv.lookup_type,inv.value_set_id
164: from pay_input_values_f inv
165: where inv.element_type_id = p_ele_type_id
166: and p_eff_date between inv.effective_start_date
167: and inv.effective_end_date
168: order by inv.display_sequence

Line 171: l_uom pay_input_values_f.uom%TYPE;

167: and inv.effective_end_date
168: order by inv.display_sequence
169: , inv.name;
170: --
171: l_uom pay_input_values_f.uom%TYPE;
172: --
173: l_lookup_type pay_input_values_f.lookup_type%TYPE;
174: l_value_set_id pay_input_values_f.value_set_id%TYPE;
175: l_input_curr_code pay_element_types_f.input_currency_code%TYPE;

Line 173: l_lookup_type pay_input_values_f.lookup_type%TYPE;

169: , inv.name;
170: --
171: l_uom pay_input_values_f.uom%TYPE;
172: --
173: l_lookup_type pay_input_values_f.lookup_type%TYPE;
174: l_value_set_id pay_input_values_f.value_set_id%TYPE;
175: l_input_curr_code pay_element_types_f.input_currency_code%TYPE;
176: --
177: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;

Line 174: l_value_set_id pay_input_values_f.value_set_id%TYPE;

170: --
171: l_uom pay_input_values_f.uom%TYPE;
172: --
173: l_lookup_type pay_input_values_f.lookup_type%TYPE;
174: l_value_set_id pay_input_values_f.value_set_id%TYPE;
175: l_input_curr_code pay_element_types_f.input_currency_code%TYPE;
176: --
177: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;
178: l_element_name pay_element_types_f.element_name%TYPE := null;

Line 1629: l_uom pay_input_values_f.uom%TYPE;

1625: l_batch_control_id pay_batch_control_totals.batch_control_id%TYPE;
1626: l_object_version_number pay_batch_control_totals.object_version_number%TYPE;
1627: l_session_date date;
1628: /* Changes for Bug 10373368 starts here */
1629: l_uom pay_input_values_f.uom%TYPE;
1630: l_input_curr_code pay_element_types_f.input_currency_code%TYPE;
1631: lv_rgrflg varchar2(1);
1632: v_control_total pay_batch_control_totals.control_total%TYPE;
1633: --

Line 1640: from pay_input_values_f pivf, pay_element_types_f petf, pay_batch_lines pbl

1636: p_control_type varchar2,
1637: p_control_column_name varchar2
1638: ) is
1639: select distinct petf.input_currency_code, pivf.uom
1640: from pay_input_values_f pivf, pay_element_types_f petf, pay_batch_lines pbl
1641: where pbl.batch_id = p_batch_id
1642: and pbl.element_type_id = petf.element_type_id
1643: and petf.element_type_id = pivf.element_type_id
1644: and pivf.uom <> 'D'