eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on PAY_ACTION_INFORMATION

Line 121: from pay_action_information pai,

117: and ppt.action_status = 'C'
118: and rownum =1 ;
119: */
120: select 'TRUE'
121: from pay_action_information pai,
122: pay_assignment_actions paa
123: where paa.action_status = 'C'
124: and pai.action_information_category = 'JP_PRE_TAX_1'
125: and pai.action_context_type = 'AAP'

Line 165: from pay_action_information pai,

161: and ppt.assignment_action_id = paa.assignment_action_id
162: and ppt.action_status = 'C');
163: */
164: select 'Y'
165: from pay_action_information pai,
166: pay_assignment_actions paa
167: where paa.assignment_id = p_assignment_id
168: and paa.action_status = 'C'
169: and pai.action_information_category = 'JP_PRE_TAX_1'

Line 201: from pay_action_information pai,

197: cursor csr_assact is
198: select pai.action_information29 disaster_tax_reduction,
199: pai.action_information_id,
200: paa.assignment_action_id
201: from pay_action_information pai,
202: pay_assignment_actions paa
203: where paa.assignment_id = p_assignment_id
204: and paa.action_status = 'C'
205: and pai.action_information_category = 'JP_PRE_TAX_1'

Line 242: update pay_action_information

238: for l_assact in csr_assact loop
239: l_balance := pay_balance_pkg.get_value(l_defined_balance_id, l_assact.assignment_action_id);
240: --
241: if l_balance <> l_assact.disaster_tax_reduction then
242: update pay_action_information
243: set action_information29 = l_balance --Disaster Tax Reduction
244: where action_information_id = l_assact.action_information_id;
245: /*
246: update pay_jp_pre_tax

Line 1233: from pay_action_information

1229: where paa.action_status = 'C'
1230: and ppt.assignment_action_id = paa.assignment_action_id
1231: and ppt.assignment_action_id NOT IN (
1232: select action_information1
1233: from pay_action_information
1234: where action_information_category = 'JP_PRE_TAX_1'
1235: and action_context_type = 'AAP')
1236: and rownum =1;
1237:

Line 1269: from pay_action_information

1265: and paa.action_status = 'C'
1266: and ppt.assignment_action_id = paa.assignment_action_id
1267: and ppt.assignment_action_id NOT IN (
1268: select action_information1
1269: from pay_action_information
1270: where action_information_category = 'JP_PRE_TAX_1'
1271: and action_context_type = 'AAP')
1272: and rownum = 1;
1273:

Line 1302: l_action_info_id1 pay_action_information.action_information_id%TYPE;

1298: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1299: l_employment_category per_all_assignments.employment_category%TYPE;
1300: l_effective_date pay_payroll_actions.effective_date%TYPE;
1301: --
1302: l_action_info_id1 pay_action_information.action_information_id%TYPE;
1303: l_action_info_id2 pay_action_information.action_information_id%TYPE;
1304: l_ovn pay_action_information.object_version_number%TYPE;
1305: --
1306: cursor csr_pre_tax is

Line 1303: l_action_info_id2 pay_action_information.action_information_id%TYPE;

1299: l_employment_category per_all_assignments.employment_category%TYPE;
1300: l_effective_date pay_payroll_actions.effective_date%TYPE;
1301: --
1302: l_action_info_id1 pay_action_information.action_information_id%TYPE;
1303: l_action_info_id2 pay_action_information.action_information_id%TYPE;
1304: l_ovn pay_action_information.object_version_number%TYPE;
1305: --
1306: cursor csr_pre_tax is
1307: select ppt.*, ppa.effective_date

Line 1304: l_ovn pay_action_information.object_version_number%TYPE;

1300: l_effective_date pay_payroll_actions.effective_date%TYPE;
1301: --
1302: l_action_info_id1 pay_action_information.action_information_id%TYPE;
1303: l_action_info_id2 pay_action_information.action_information_id%TYPE;
1304: l_ovn pay_action_information.object_version_number%TYPE;
1305: --
1306: cursor csr_pre_tax is
1307: select ppt.*, ppa.effective_date
1308: from pay_jp_pre_tax_old ppt,

Line 1315: from pay_action_information pai

1311: where paa.assignment_id = p_assignment_id
1312: and paa.assignment_action_id = ppt.assignment_action_id
1313: and paa.payroll_action_id = ppa.payroll_action_id
1314: and not exists ( select 1
1315: from pay_action_information pai
1316: where ppt.assignment_action_id = pai.action_information1
1317: and paa.assignment_id = pai.assignment_id
1318: and pai.action_information_category = 'JP_PRE_TAX_1'
1319: and pai.action_context_type = 'AAP'

Line 1393: pay_action_information_api.create_action_information

1389: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1390: hr_utility.trace('disaster_tax_reduction : ' || l_pre_tax.disaster_tax_reduction);
1391: hr_utility.trace('sp_ltax_district_code : ' || l_pre_tax.sp_ltax_district_code);
1392: --
1393: pay_action_information_api.create_action_information
1394: (
1395: p_action_information_id => l_action_info_id1
1396: ,p_action_context_id => l_pre_tax.assignment_action_id
1397: ,p_action_context_type => 'AAP'

Line 1432: pay_action_information_api.create_action_information

1428: ,p_action_information29 => fnd_number.number_to_canonical(l_pre_tax.disaster_tax_reduction)
1429: ,p_action_information30 => l_employment_category
1430: );
1431:
1432: pay_action_information_api.create_action_information
1433: (
1434: p_action_information_id => l_action_info_id2
1435: ,p_action_context_id => l_pre_tax.assignment_action_id
1436: ,p_action_context_type => 'AAP'

Line 1694: from pay_action_information pai

1690: and pay_core_utils.get_parameter('INCLUDE_TERMINATED_FLAG', legislative_parameters) is null;
1691: /*
1692: and not exists(
1693: select null
1694: from pay_action_information pai
1695: where pai.action_context_id = ppa.payroll_action_id
1696: and pai.action_context_type = 'PA'
1697: and pai.action_information_category = 'JP_ITAX_PACT');
1698: */

Line 1760: pay_action_information_api.create_action_information(

1756: update pay_payroll_actions
1757: set legislative_parameters = l_legislative_parameters
1758: where payroll_action_id = l_pact.payroll_action_id;
1759: --
1760: pay_action_information_api.create_action_information(
1761: p_validate => false,
1762: p_action_context_id => l_pact.payroll_action_id,
1763: p_action_context_type => 'PA',
1764: p_action_information_category => 'JP_ITAX_PACT',

Line 1880: pay_action_information person,

1876: other2.ACTION_INFORMATION21 WTM_SYSTEM_DESC_KANA_1,
1877: other2.ACTION_INFORMATION22 WTM_SYSTEM_DESC_KANA_2
1878: from pay_assignment_actions paa,
1879: pay_payroll_actions ppa,
1880: pay_action_information person,
1881: pay_action_information arch,
1882: pay_action_information other2
1883: where paa.assignment_id = p_assignment_id
1884: and paa.action_status = 'C'

Line 1881: pay_action_information arch,

1877: other2.ACTION_INFORMATION22 WTM_SYSTEM_DESC_KANA_2
1878: from pay_assignment_actions paa,
1879: pay_payroll_actions ppa,
1880: pay_action_information person,
1881: pay_action_information arch,
1882: pay_action_information other2
1883: where paa.assignment_id = p_assignment_id
1884: and paa.action_status = 'C'
1885: and ppa.payroll_action_id = paa.payroll_action_id

Line 1882: pay_action_information other2

1878: from pay_assignment_actions paa,
1879: pay_payroll_actions ppa,
1880: pay_action_information person,
1881: pay_action_information arch,
1882: pay_action_information other2
1883: where paa.assignment_id = p_assignment_id
1884: and paa.action_status = 'C'
1885: and ppa.payroll_action_id = paa.payroll_action_id
1886: and ppa.action_type = 'X'

Line 1912: update pay_action_information

1908: for l_rec in csr loop
1909: --
1910: -- JP_ITAX_PERSON
1911: --
1912: update pay_action_information
1913: set action_information11 = to_canonical_date(action_information11),
1914: action_information13 = to_canonical_date(action_information13),
1915: action_information25 = to_canonical_date(action_information25),
1916: -- action_information27 = 'O'

Line 1922: update pay_action_information

1918: where rowid = l_rec.person_rowid;
1919: --
1920: -- JP_ITAX_ARCH
1921: --
1922: update pay_action_information
1923: set action_information12 = to_canonical_date(action_information12)
1924: where rowid = l_rec.arch_rowid;
1925: --
1926: -- JP_ITAX_OTHER2

Line 1985: update pay_action_information

1981: l_rec.WTM_SYSTEM_DESC_KANA_1 := hr_jp_standard_pkg.get_index_at(l_varchar2_tbl, 1);
1982: l_rec.WTM_SYSTEM_DESC_KANA_2 := hr_jp_standard_pkg.get_index_at(l_varchar2_tbl, 2);
1983: end if;
1984: --
1985: update pay_action_information
1986: set ACTION_INFORMATION23 = l_rec.ITW_SYSTEM_DESC1_KANJI,
1987: ACTION_INFORMATION15 = l_rec.ITW_SYSTEM_DESC2_KANJI_1,
1988: ACTION_INFORMATION16 = l_rec.ITW_SYSTEM_DESC2_KANJI_2,
1989: ACTION_INFORMATION19 = l_rec.WTM_SYSTEM_DESC_KANJI_1,