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 866: pay_link_input_values_f pliv,

862: pee.element_entry_id,
863: decode(piv.hot_default_flag, 'Y', null, nvl(pliv.default_value, piv.default_value))
864: from pay_element_entries_f pee,
865: pay_element_links_f pel,
866: pay_link_input_values_f pliv,
867: pay_input_values_f piv
868: where pee.assignment_id = p_assignment_id
869: and pel.element_link_id = pee.element_link_id
870: and pee.effective_start_date

Line 1077: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.

1073: l_element_type_id3 number;
1074: begin
1075: hr_utility.set_location('Entering: ' || c_proc, 10);
1076: --
1077: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
1078: --
1079: init_pay_a;
1080: --
1081: for i in 1..g_element_type_ids.count loop

Line 1146: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.

1142: --
1143: hr_utility.set_location('Entering: ' || c_proc, 10);
1144: --
1145: --
1146: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
1147: --
1148: if g_element_type_ids.count = 0 then
1149: --
1150: get_element_type_id('YEA_WITHHOLD_TAX_REPORT_INFO', g_element_type_ids);

Line 1505: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.

1501: --
1502: end if;
1503: --
1504: for i in 1..g_element_type_ids.count loop
1505: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
1506: pay_jp_generic_upgrade_pkg.sync_link_input_values(g_element_type_ids(i));
1507: --
1508: end loop;
1509: --

Line 1604: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.

1600: c_proc constant varchar2(61) := c_package || 'validate_yea_earthquake_ins';
1601: begin
1602: hr_utility.set_location('Entering: ' || c_proc, 10);
1603: --
1604: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
1605: --
1606: init_yea_earthquake_ins;
1607: --
1608: for i in 1..g_element_type_ids.count loop

Line 2228: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.

2224: --
2225: init_adj_ann_std_bon;
2226: --
2227: for i in 1..g_element_type_ids.count loop
2228: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
2229: pay_jp_generic_upgrade_pkg.sync_link_input_values(g_element_type_ids(i));
2230: --
2231: end loop;
2232: --

Line 2500: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.

2496: begin
2497: --
2498: hr_utility.set_location('Entering: ' || c_proc, 10);
2499: --
2500: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
2501: --
2502: init_yea_ins_dct;
2503: --
2504: for i in 1..g_element_type_ids.count loop

Line 2598: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.

2594: c_proc constant varchar2(61) := c_package || 'validate_yea_ins_prem_2012';
2595: begin
2596: hr_utility.set_location('Entering: ' || c_proc, 10);
2597: --
2598: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
2599: --
2600: init_yea_ins_prem_2012;
2601: --
2602: for i in 1..g_element_type_ids.count loop

Line 2685: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.

2681: c_proc constant varchar2(61) := c_package || 'validate_net_annual_tax_2013';
2682: begin
2683: hr_utility.set_location('Entering: ' || c_proc, 10);
2684: --
2685: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
2686: --
2687: init_net_annual_tax_2013;
2688: --
2689: for i in 1..g_element_type_ids.count loop

Line 2773: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.

2769: c_proc constant varchar2(61) := c_package || 'validate_spc_exec_2013';
2770: begin
2771: hr_utility.set_location('Entering: ' || c_proc, 10);
2772: --
2773: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
2774: --
2775: init_spc_exec_2013;
2776: --
2777: for i in 1..g_element_type_ids.count loop