DBA Data[Home] [Help]

APPS.PAY_FR_BAL_UPLOAD dependencies on PAY_LEGISLATION_CONTEXTS

Line 264: iv_name pay_legislation_contexts.input_value_name%TYPE,

260: p_batch_id in number)
261: ------------------------------------------------------------------------
262: is
263: type t_cxt_iv is record (
264: iv_name pay_legislation_contexts.input_value_name%TYPE,
265: UOM pay_input_values_f.uom%TYPE);
266: type t_cxt_ivs is table of t_cxt_iv index by binary_integer;
267: tbl_cxt_ivs t_cxt_ivs;
268: --

Line 294: from pay_legislation_contexts lc,

290: --
291: Cursor csr_cxt_ivs is
292: select lc.input_value_name,
293: decode(c.data_type,'T','C',c.data_type) UOM
294: from pay_legislation_contexts lc,
295: ff_contexts c
296: where c.context_id = lc.context_id
297: and lc.input_value_name is not null
298: and lc.legislation_code = l_legislation_code;