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 1239: from pay_action_information

1235: where paa.action_status = 'C'
1236: and ppt.assignment_action_id = paa.assignment_action_id
1237: and ppt.assignment_action_id NOT IN (
1238: select action_information1
1239: from pay_action_information
1240: where action_information_category = 'JP_PRE_TAX_1'
1241: and action_context_type = 'AAP')
1242: and rownum =1;
1243:

Line 1275: from pay_action_information

1271: and paa.action_status = 'C'
1272: and ppt.assignment_action_id = paa.assignment_action_id
1273: and ppt.assignment_action_id NOT IN (
1274: select action_information1
1275: from pay_action_information
1276: where action_information_category = 'JP_PRE_TAX_1'
1277: and action_context_type = 'AAP')
1278: and rownum = 1;
1279:

Line 1308: l_action_info_id1 pay_action_information.action_information_id%TYPE;

1304: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1305: l_employment_category per_all_assignments.employment_category%TYPE;
1306: l_effective_date pay_payroll_actions.effective_date%TYPE;
1307: --
1308: l_action_info_id1 pay_action_information.action_information_id%TYPE;
1309: l_action_info_id2 pay_action_information.action_information_id%TYPE;
1310: l_ovn pay_action_information.object_version_number%TYPE;
1311: --
1312: cursor csr_pre_tax is

Line 1309: l_action_info_id2 pay_action_information.action_information_id%TYPE;

1305: l_employment_category per_all_assignments.employment_category%TYPE;
1306: l_effective_date pay_payroll_actions.effective_date%TYPE;
1307: --
1308: l_action_info_id1 pay_action_information.action_information_id%TYPE;
1309: l_action_info_id2 pay_action_information.action_information_id%TYPE;
1310: l_ovn pay_action_information.object_version_number%TYPE;
1311: --
1312: cursor csr_pre_tax is
1313: select ppt.*, ppa.effective_date

Line 1310: l_ovn pay_action_information.object_version_number%TYPE;

1306: l_effective_date pay_payroll_actions.effective_date%TYPE;
1307: --
1308: l_action_info_id1 pay_action_information.action_information_id%TYPE;
1309: l_action_info_id2 pay_action_information.action_information_id%TYPE;
1310: l_ovn pay_action_information.object_version_number%TYPE;
1311: --
1312: cursor csr_pre_tax is
1313: select ppt.*, ppa.effective_date
1314: from pay_jp_pre_tax_old ppt,

Line 1321: from pay_action_information pai

1317: where paa.assignment_id = p_assignment_id
1318: and paa.assignment_action_id = ppt.assignment_action_id
1319: and paa.payroll_action_id = ppa.payroll_action_id
1320: and not exists ( select 1
1321: from pay_action_information pai
1322: where ppt.assignment_action_id = pai.action_information1
1323: and paa.assignment_id = pai.assignment_id
1324: and pai.action_information_category = 'JP_PRE_TAX_1'
1325: and pai.action_context_type = 'AAP'

Line 1399: pay_action_information_api.create_action_information

1395: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1396: hr_utility.trace('disaster_tax_reduction : ' || l_pre_tax.disaster_tax_reduction);
1397: hr_utility.trace('sp_ltax_district_code : ' || l_pre_tax.sp_ltax_district_code);
1398: --
1399: pay_action_information_api.create_action_information
1400: (
1401: p_action_information_id => l_action_info_id1
1402: ,p_action_context_id => l_pre_tax.assignment_action_id
1403: ,p_action_context_type => 'AAP'

Line 1438: pay_action_information_api.create_action_information

1434: ,p_action_information29 => fnd_number.number_to_canonical(l_pre_tax.disaster_tax_reduction)
1435: ,p_action_information30 => l_employment_category
1436: );
1437:
1438: pay_action_information_api.create_action_information
1439: (
1440: p_action_information_id => l_action_info_id2
1441: ,p_action_context_id => l_pre_tax.assignment_action_id
1442: ,p_action_context_type => 'AAP'

Line 1700: from pay_action_information pai

1696: and pay_core_utils.get_parameter('INCLUDE_TERMINATED_FLAG', legislative_parameters) is null;
1697: /*
1698: and not exists(
1699: select null
1700: from pay_action_information pai
1701: where pai.action_context_id = ppa.payroll_action_id
1702: and pai.action_context_type = 'PA'
1703: and pai.action_information_category = 'JP_ITAX_PACT');
1704: */

Line 1766: pay_action_information_api.create_action_information(

1762: update pay_payroll_actions
1763: set legislative_parameters = l_legislative_parameters
1764: where payroll_action_id = l_pact.payroll_action_id;
1765: --
1766: pay_action_information_api.create_action_information(
1767: p_validate => false,
1768: p_action_context_id => l_pact.payroll_action_id,
1769: p_action_context_type => 'PA',
1770: p_action_information_category => 'JP_ITAX_PACT',

Line 1886: pay_action_information person,

1882: other2.ACTION_INFORMATION21 WTM_SYSTEM_DESC_KANA_1,
1883: other2.ACTION_INFORMATION22 WTM_SYSTEM_DESC_KANA_2
1884: from pay_assignment_actions paa,
1885: pay_payroll_actions ppa,
1886: pay_action_information person,
1887: pay_action_information arch,
1888: pay_action_information other2
1889: where paa.assignment_id = p_assignment_id
1890: and paa.action_status = 'C'

Line 1887: pay_action_information arch,

1883: other2.ACTION_INFORMATION22 WTM_SYSTEM_DESC_KANA_2
1884: from pay_assignment_actions paa,
1885: pay_payroll_actions ppa,
1886: pay_action_information person,
1887: pay_action_information arch,
1888: pay_action_information other2
1889: where paa.assignment_id = p_assignment_id
1890: and paa.action_status = 'C'
1891: and ppa.payroll_action_id = paa.payroll_action_id

Line 1888: pay_action_information other2

1884: from pay_assignment_actions paa,
1885: pay_payroll_actions ppa,
1886: pay_action_information person,
1887: pay_action_information arch,
1888: pay_action_information other2
1889: where paa.assignment_id = p_assignment_id
1890: and paa.action_status = 'C'
1891: and ppa.payroll_action_id = paa.payroll_action_id
1892: and ppa.action_type = 'X'

Line 1918: update pay_action_information

1914: for l_rec in csr loop
1915: --
1916: -- JP_ITAX_PERSON
1917: --
1918: update pay_action_information
1919: set action_information11 = to_canonical_date(action_information11),
1920: action_information13 = to_canonical_date(action_information13),
1921: action_information25 = to_canonical_date(action_information25),
1922: -- action_information27 = 'O'

Line 1928: update pay_action_information

1924: where rowid = l_rec.person_rowid;
1925: --
1926: -- JP_ITAX_ARCH
1927: --
1928: update pay_action_information
1929: set action_information12 = to_canonical_date(action_information12)
1930: where rowid = l_rec.arch_rowid;
1931: --
1932: -- JP_ITAX_OTHER2

Line 1991: update pay_action_information

1987: l_rec.WTM_SYSTEM_DESC_KANA_1 := hr_jp_standard_pkg.get_index_at(l_varchar2_tbl, 1);
1988: l_rec.WTM_SYSTEM_DESC_KANA_2 := hr_jp_standard_pkg.get_index_at(l_varchar2_tbl, 2);
1989: end if;
1990: --
1991: update pay_action_information
1992: set ACTION_INFORMATION23 = l_rec.ITW_SYSTEM_DESC1_KANJI,
1993: ACTION_INFORMATION15 = l_rec.ITW_SYSTEM_DESC2_KANJI_1,
1994: ACTION_INFORMATION16 = l_rec.ITW_SYSTEM_DESC2_KANJI_2,
1995: ACTION_INFORMATION19 = l_rec.WTM_SYSTEM_DESC_KANJI_1,