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_PAYROLL_ACTIONS

Line 608: INDEX(PPA PAY_PAYROLL_ACTIONS_FK1)

604: or exists(
605: select /*+ ORDERED
606: NO_MERGE(BG)
607: USE_NL(PPA PAA PRR)
608: INDEX(PPA PAY_PAYROLL_ACTIONS_FK1)
609: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N50)
610: INDEX(PRR PAY_RUN_RESULTS_N50) */
611: null
612: from per_business_groups_perf bg,

Line 613: pay_payroll_actions ppa,

609: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N50)
610: INDEX(PRR PAY_RUN_RESULTS_N50) */
611: null
612: from per_business_groups_perf bg,
613: pay_payroll_actions ppa,
614: pay_assignment_actions paa,
615: pay_run_results prr
616: where bg.legislation_code = p_legislation_code
617: and ppa.business_group_id = bg.business_group_id

Line 929: -- INDEX(PPA PAY_PAYROLL_ACTIONS_PK)

925: -- select /*+ ORDERED
926: -- USE_NL(PRR PPA PIV)
927: -- INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N1)
928: -- INDEX(PRR PAY_RUN_RESULTS_N50)
929: -- INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
930: -- INDEX(PIV PAY_INPUT_VALUES_F_N50) */
931: -- piv.input_value_id,
932: -- prr.run_result_id,
933: -- null

Line 936: -- pay_payroll_actions ppa,

932: -- prr.run_result_id,
933: -- null
934: -- from pay_assignment_actions paa,
935: -- pay_run_results prr,
936: -- pay_payroll_actions ppa,
937: -- pay_input_values_f piv
938: -- where paa.assignment_id = p_assignment_id
939: -- and prr.assignment_action_id = paa.assignment_action_id
940: -- and prr.element_type_id = p_element_type_id

Line 966: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)

962: RUN_RESULT_ID,
963: RESULT_VALUE)
964: select /*+ INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)
965: INDEX(PRR PAY_RUN_RESULTS_N50)
966: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
967: INDEX(PIV PAY_INPUT_VALUES_F_N50) */
968: piv.input_value_id,
969: prr.run_result_id,
970: null

Line 973: pay_payroll_actions ppa,

969: prr.run_result_id,
970: null
971: from pay_assignment_actions paa,
972: pay_run_results prr,
973: pay_payroll_actions ppa,
974: pay_input_values_f piv
975: where paa.assignment_id = p_assignment_id
976: and prr.assignment_action_id = paa.assignment_action_id
977: and prr.element_type_id = p_element_type_id

Line 1300: l_effective_date pay_payroll_actions.effective_date%TYPE;

1296: l_date_start per_periods_of_service.date_start%TYPE;
1297: l_leaving_reason per_periods_of_service.leaving_reason%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;

Line 1310: pay_payroll_actions ppa

1306: cursor csr_pre_tax is
1307: select ppt.*, ppa.effective_date
1308: from pay_jp_pre_tax_old ppt,
1309: pay_assignment_actions paa,
1310: pay_payroll_actions ppa
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

Line 1665: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;

1661: -- |-------------------------------------------------------------------|
1662: procedure validate_itw_archive(p_valid_upgrade out nocopy varchar2)
1663: is
1664: c_proc constant varchar2(61) := c_package || 'validate_itw_archive';
1665: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
1666: l_payroll_id number;
1667: l_itax_organization_id number;
1668: l_include_terminated_flag varchar2(1);
1669: l_termination_date_from date;

Line 1684: from pay_payroll_actions ppa

1680: cursor csr_pacts is
1681: select payroll_action_id,
1682: effective_date,
1683: legislative_parameters
1684: from pay_payroll_actions ppa
1685: where ppa.action_type = 'X'
1686: and ppa.report_type = 'JPTW'
1687: and ppa.report_qualifier = 'JP'
1688: and ppa.report_category = 'ARCHIVE'

Line 1756: update pay_payroll_actions

1752: --
1753: hr_utility.trace('payroll_action_id: ' || l_pact.payroll_action_id);
1754: hr_utility.trace('legislative_parameters: ' || l_legislative_parameters);
1755: --
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(

Line 1800: pay_payroll_actions ppa

1796: from dual
1797: where exists(
1798: select null
1799: from pay_assignment_actions paa,
1800: pay_payroll_actions ppa
1801: where paa.assignment_id = p_assignment_id
1802: and paa.action_status = 'C'
1803: and ppa.payroll_action_id = paa.payroll_action_id
1804: and ppa.action_type = 'X'

Line 1879: pay_payroll_actions ppa,

1875: other2.ACTION_INFORMATION20 WTM_SYSTEM_DESC_KANJI_2,
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