APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on PAY_LINK_INPUT_VALUES_F

Line 793: from pay_link_input_values_f pliv

789: and pel.effective_start_date
790: between piv.effective_start_date and piv.effective_end_date
791: and not exists(
792: select null
793: from pay_link_input_values_f pliv
794: where pliv.element_link_id = pel.element_link_id
795: and pliv.input_value_id = piv.input_value_id)
796: group by pel.element_link_id, piv.input_value_id;
797: begin

Line 862: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_U50)

858: select /*+ ORDERED
859: USE_NL(PEL PLIV PIV)
860: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N50)
861: INDEX(PEL PAY_ELEMENT_LINKS_F_PK)
862: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_U50)
863: INDEX(PIV PAY_INPUT_VALUES_F_PK) */
864: pay_element_entry_values_s.nextval,
865: pee.effective_start_date,
866: pee.effective_end_date,

Line 872: pay_link_input_values_f pliv,

868: pee.element_entry_id,
869: decode(piv.hot_default_flag, 'Y', null, nvl(pliv.default_value, piv.default_value))
870: from pay_element_entries_f pee,
871: pay_element_links_f pel,
872: pay_link_input_values_f pliv,
873: pay_input_values_f piv
874: where pee.assignment_id = p_assignment_id
875: and pel.element_link_id = pee.element_link_id
876: and pee.effective_start_date

Line 1083: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.

1079: l_element_type_id3 number;
1080: begin
1081: hr_utility.set_location('Entering: ' || c_proc, 10);
1082: --
1083: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
1084: --
1085: init_pay_a;
1086: --
1087: for i in 1..g_element_type_ids.count loop

Line 1152: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.

1148: --
1149: hr_utility.set_location('Entering: ' || c_proc, 10);
1150: --
1151: --
1152: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
1153: --
1154: if g_element_type_ids.count = 0 then
1155: --
1156: get_element_type_id('YEA_WITHHOLD_TAX_REPORT_INFO', g_element_type_ids);

Line 1511: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.

1507: --
1508: end if;
1509: --
1510: for i in 1..g_element_type_ids.count loop
1511: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
1512: pay_jp_generic_upgrade_pkg.sync_link_input_values(g_element_type_ids(i));
1513: --
1514: end loop;
1515: --

Line 1610: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.

1606: c_proc constant varchar2(61) := c_package || 'validate_yea_earthquake_ins';
1607: begin
1608: hr_utility.set_location('Entering: ' || c_proc, 10);
1609: --
1610: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
1611: --
1612: init_yea_earthquake_ins;
1613: --
1614: for i in 1..g_element_type_ids.count loop

Line 2234: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.

2230: --
2231: init_adj_ann_std_bon;
2232: --
2233: for i in 1..g_element_type_ids.count loop
2234: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
2235: pay_jp_generic_upgrade_pkg.sync_link_input_values(g_element_type_ids(i));
2236: --
2237: end loop;
2238: --