APPS.PAY_BALANCE_UPLOAD dependencies on PAY_INPUT_VALUES_F

Line 318: ,jurisdiction_iv pay_input_values_f.name%type

314: ,assignment_id pay_balance_batch_lines.assignment_id%type
315: ,batch_header_status pay_balance_batch_headers.batch_status%type
316: ,batch_line_status pay_balance_batch_lines.batch_line_status%type
317: ,chunk_size number(9)
318: ,jurisdiction_iv pay_input_values_f.name%type
319: ,include_adj_rule pay_legislation_rules.rule_mode%type
320: );
321:
322: type g_payroll_action_rec_type is record

Line 342: input_value_id pay_input_values_f.input_value_id%type

338:
339: type t_inpval_context_rec is record
340: (
341: context_name ff_contexts.context_name%type,
342: input_value_id pay_input_values_f.input_value_id%type
343: );
344: type t_inpval_context_tab is table of t_inpval_context_rec
345: index by binary_integer;
346:

Line 1813: l_iv_id pay_input_values_f.input_value_id%type;

1809: p_start_ptr out nocopy number,
1810: p_end_ptr out nocopy number
1811: )
1812: is
1813: l_iv_id pay_input_values_f.input_value_id%type;
1814: l_start_ptr number;
1815: l_ptr number;
1816: begin
1817: --

Line 1844: from pay_input_values_f piv,

1840: -- OK does this element have this legislation context
1841: begin
1842: select piv.input_value_id
1843: into l_iv_id
1844: from pay_input_values_f piv,
1845: pay_element_links_f pel
1846: where pel.element_link_id= p_element_link_id
1847: and pel.element_type_id = piv.element_type_id
1848: and piv.name = g_legislation_contexts(i).input_value_name

Line 1902: l_iv_id pay_input_values_f.input_value_id%type;

1898: is
1899: --
1900: l_start_ptr number;
1901: l_end_ptr number;
1902: l_iv_id pay_input_values_f.input_value_id%type;
1903: cnt number;
1904: found boolean;
1905: --
1906: begin

Line 4244: ,pay_input_values_f IV

4240: 0, null,
4241: IV2.input_value_id) jc_input_value_id
4242: from pay_balance_types BT
4243: ,pay_balance_feeds_f BF
4244: ,pay_input_values_f IV
4245: ,pay_input_values_f IV2
4246: ,pay_element_types_f ET
4247: ,pay_element_classifications EC
4248: where BF.balance_type_id = p_balance_type_id

Line 4245: ,pay_input_values_f IV2

4241: IV2.input_value_id) jc_input_value_id
4242: from pay_balance_types BT
4243: ,pay_balance_feeds_f BF
4244: ,pay_input_values_f IV
4245: ,pay_input_values_f IV2
4246: ,pay_element_types_f ET
4247: ,pay_element_classifications EC
4248: where BF.balance_type_id = p_balance_type_id
4249: and BT.balance_type_id = BF.balance_type_id