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_BEE_UPGRADE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 120: TYPE input_currency_code_tbl IS TABLE OF pay_element_types_f.input_currency_code%TYPE INDEX BY binary_integer;

116: --
117: --
118: g_rec csr_batch_lines%ROWTYPE;
119: --
120: TYPE input_currency_code_tbl IS TABLE OF pay_element_types_f.input_currency_code%TYPE INDEX BY binary_integer;
121: TYPE name_tbl IS TABLE OF pay_input_values_f.name%TYPE INDEX BY binary_integer;
122: TYPE display_sequence_tbl IS TABLE OF pay_input_values_f.display_sequence%TYPE INDEX BY binary_integer;
123: TYPE uom_tbl IS TABLE OF pay_input_values_f.uom%TYPE INDEX BY binary_integer;
124: TYPE lookup_type_tbl IS TABLE OF pay_input_values_f.lookup_type%TYPE INDEX BY binary_integer;

Line 136: g_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;

132: lookup_type lookup_type_tbl,
133: value_set_id value_set_id_tbl);
134: --
135: g_input_values input_value_tbl_rec;
136: g_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;
137: g_element_name pay_element_types_f.element_name%TYPE := NULL;
138: g_effective_date pay_batch_lines.effective_date%TYPE := NULL;
139: g_business_group_id per_business_groups.business_group_id%TYPE := NULL;
140: g_legislation_code per_business_groups.legislation_code%TYPE := NULL;

Line 137: g_element_name pay_element_types_f.element_name%TYPE := NULL;

133: value_set_id value_set_id_tbl);
134: --
135: g_input_values input_value_tbl_rec;
136: g_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;
137: g_element_name pay_element_types_f.element_name%TYPE := NULL;
138: g_effective_date pay_batch_lines.effective_date%TYPE := NULL;
139: g_business_group_id per_business_groups.business_group_id%TYPE := NULL;
140: g_legislation_code per_business_groups.legislation_code%TYPE := NULL;
141: --

Line 143: element_type_id pay_element_types_f.element_type_id%TYPE,

139: g_business_group_id per_business_groups.business_group_id%TYPE := NULL;
140: g_legislation_code per_business_groups.legislation_code%TYPE := NULL;
141: --
142: type input_value_rec is record(
143: element_type_id pay_element_types_f.element_type_id%TYPE,
144: element_name pay_element_types_f.element_name%TYPE,
145: input_currency_code pay_element_types_f.input_currency_code%TYPE,
146: name pay_input_values_f.name%TYPE,
147: display_sequence pay_input_values_f.display_sequence%TYPE,

Line 144: element_name pay_element_types_f.element_name%TYPE,

140: g_legislation_code per_business_groups.legislation_code%TYPE := NULL;
141: --
142: type input_value_rec is record(
143: element_type_id pay_element_types_f.element_type_id%TYPE,
144: element_name pay_element_types_f.element_name%TYPE,
145: input_currency_code pay_element_types_f.input_currency_code%TYPE,
146: name pay_input_values_f.name%TYPE,
147: display_sequence pay_input_values_f.display_sequence%TYPE,
148: uom pay_input_values_f.uom%TYPE,

Line 145: input_currency_code pay_element_types_f.input_currency_code%TYPE,

141: --
142: type input_value_rec is record(
143: element_type_id pay_element_types_f.element_type_id%TYPE,
144: element_name pay_element_types_f.element_name%TYPE,
145: input_currency_code pay_element_types_f.input_currency_code%TYPE,
146: name pay_input_values_f.name%TYPE,
147: display_sequence pay_input_values_f.display_sequence%TYPE,
148: uom pay_input_values_f.uom%TYPE,
149: lookup_type pay_input_values_f.lookup_type%TYPE,

Line 173: FROM pay_element_types_f pet,

169: p_legislation_code varchar2) IS
170: SELECT piv.name,
171: piv.display_sequence, piv.uom,piv.lookup_type,
172: piv.value_set_id,pet.input_currency_code
173: FROM pay_element_types_f pet,
174: pay_input_values_f piv
175: WHERE p_element_type_id is not null
176: AND p_element_type_id = pet.element_type_id
177: AND p_effective_date BETWEEN pet.effective_start_date

Line 186: FROM pay_element_types_f pet,

182: UNION ALL
183: SELECT piv.name,
184: piv.display_sequence, piv.uom,piv.lookup_type,
185: piv.value_set_id,pet.input_currency_code
186: FROM pay_element_types_f pet,
187: pay_input_values_f piv
188: WHERE p_element_type_id is null
189: AND upper(p_element_name) = upper(pet.element_name)
190: AND (pet.business_group_id = p_business_group_id OR