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_INPUT_VALUES_F

Line 121: TYPE name_tbl IS TABLE OF pay_input_values_f.name%TYPE INDEX BY binary_integer;

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;
125: TYPE value_set_id_tbl IS TABLE OF pay_input_values_f.value_set_id%TYPE INDEX BY binary_integer;

Line 122: TYPE display_sequence_tbl IS TABLE OF pay_input_values_f.display_sequence%TYPE INDEX BY binary_integer;

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;
125: TYPE value_set_id_tbl IS TABLE OF pay_input_values_f.value_set_id%TYPE INDEX BY binary_integer;
126: --

Line 123: TYPE uom_tbl IS TABLE OF pay_input_values_f.uom%TYPE INDEX BY binary_integer;

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;
125: TYPE value_set_id_tbl IS TABLE OF pay_input_values_f.value_set_id%TYPE INDEX BY binary_integer;
126: --
127: type input_value_tbl_rec is record(

Line 124: TYPE lookup_type_tbl IS TABLE OF pay_input_values_f.lookup_type%TYPE INDEX BY binary_integer;

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;
125: TYPE value_set_id_tbl IS TABLE OF pay_input_values_f.value_set_id%TYPE INDEX BY binary_integer;
126: --
127: type input_value_tbl_rec is record(
128: input_currency_code input_currency_code_tbl,

Line 125: TYPE value_set_id_tbl IS TABLE OF pay_input_values_f.value_set_id%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;
125: TYPE value_set_id_tbl IS TABLE OF pay_input_values_f.value_set_id%TYPE INDEX BY binary_integer;
126: --
127: type input_value_tbl_rec is record(
128: input_currency_code input_currency_code_tbl,
129: name name_tbl,

Line 146: name pay_input_values_f.name%TYPE,

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,
150: value_set_id pay_input_values_f.value_set_id%TYPE);

Line 147: display_sequence pay_input_values_f.display_sequence%TYPE,

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,
150: value_set_id pay_input_values_f.value_set_id%TYPE);
151: --

Line 148: uom pay_input_values_f.uom%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,
150: value_set_id pay_input_values_f.value_set_id%TYPE);
151: --
152: --

Line 149: lookup_type pay_input_values_f.lookup_type%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,
150: value_set_id pay_input_values_f.value_set_id%TYPE);
151: --
152: --
153: -- -------------------------------------------------------------------------

Line 150: value_set_id pay_input_values_f.value_set_id%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,
150: value_set_id pay_input_values_f.value_set_id%TYPE);
151: --
152: --
153: -- -------------------------------------------------------------------------
154: -- Procedure to get the input values for a given element type id.

Line 174: pay_input_values_f piv

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
178: AND pet.effective_end_date

Line 187: pay_input_values_f piv

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
191: (pet.business_group_id is null AND pet.legislation_code = p_legislation_code) OR