APPS.PAY_BALANCE_UPLOAD dependencies on PAY_INPUT_VALUES_F

Line 320: ,jurisdiction_iv pay_input_values_f.name%type

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

Line 344: input_value_id pay_input_values_f.input_value_id%type

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

Line 1815: l_iv_id pay_input_values_f.input_value_id%type;

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

Line 1846: from pay_input_values_f piv,

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

Line 1904: l_iv_id pay_input_values_f.input_value_id%type;

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

Line 2100: pay_input_values_f piv

2096: select peev.screen_entry_value
2097: from pay_element_entries_f pee,
2098: pay_element_types_f pet,
2099: pay_element_entry_values_f peev,
2100: pay_input_values_f piv
2101: where pee.assignment_id = p_asg_id
2102: and pet.element_name = 'WCB'
2103: and pet.element_type_id = pee.element_type_id
2104: and pee.element_entry_id = peev.element_entry_id

Line 4537: ,pay_input_values_f IV

4533: 0, null,
4534: IV2.input_value_id) jc_input_value_id
4535: from pay_balance_types BT
4536: ,pay_balance_feeds_f BF
4537: ,pay_input_values_f IV
4538: ,pay_input_values_f IV2
4539: ,pay_element_types_f ET
4540: ,pay_element_classifications EC
4541: where BF.balance_type_id = p_balance_type_id

Line 4538: ,pay_input_values_f IV2

4534: IV2.input_value_id) jc_input_value_id
4535: from pay_balance_types BT
4536: ,pay_balance_feeds_f BF
4537: ,pay_input_values_f IV
4538: ,pay_input_values_f IV2
4539: ,pay_element_types_f ET
4540: ,pay_element_classifications EC
4541: where BF.balance_type_id = p_balance_type_id
4542: and BT.balance_type_id = BF.balance_type_id