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_ELEMENT_TYPES_F

Line 175: l_input_curr_code pay_element_types_f.input_currency_code%TYPE;

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;
179: l_count number := 0;

Line 177: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;

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;
179: l_count number := 0;
180: l_legislation_code per_business_groups.legislation_code%TYPE := null;
181: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 178: l_element_name pay_element_types_f.element_name%TYPE := null;

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;
179: l_count number := 0;
180: l_legislation_code per_business_groups.legislation_code%TYPE := null;
181: l_business_group_id per_business_groups.business_group_id%TYPE;
182: l_batch_id pay_batch_lines.batch_id%TYPE;

Line 198: from pay_element_types_f pet

194: ,p_leg_code varchar2
195: ,p_eff_date date
196: ,p_ele_id number) is
197: select pet.element_type_id,pet.input_currency_code
198: from pay_element_types_f pet
199: where p_ele_id is null
200: and upper(pet.element_name) = upper(p_ele_name)
201: and p_eff_date between pet.effective_start_date
202: and pet.effective_end_date

Line 210: from pay_element_types_f pet

206: or (pet.business_group_id is null
207: and pet.legislation_code is null))
208: union all
209: select pet.element_type_id,pet.input_currency_code
210: from pay_element_types_f pet
211: where p_ele_id is not null
212: and pet.element_type_id = p_ele_id
213: and p_eff_date between pet.effective_start_date
214: and pet.effective_end_date;

Line 1630: l_input_curr_code pay_element_types_f.input_currency_code%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: --
1634: cursor batch_total_validate

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'