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 935: -- INDEX(PPA PAY_PAYROLL_ACTIONS_PK)

931: -- select /*+ ORDERED
932: -- USE_NL(PRR PPA PIV)
933: -- INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N1)
934: -- INDEX(PRR PAY_RUN_RESULTS_N50)
935: -- INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
936: -- INDEX(PIV PAY_INPUT_VALUES_F_N50) */
937: -- piv.input_value_id,
938: -- prr.run_result_id,
939: -- null

Line 942: -- pay_payroll_actions ppa,

938: -- prr.run_result_id,
939: -- null
940: -- from pay_assignment_actions paa,
941: -- pay_run_results prr,
942: -- pay_payroll_actions ppa,
943: -- pay_input_values_f piv
944: -- where paa.assignment_id = p_assignment_id
945: -- and prr.assignment_action_id = paa.assignment_action_id
946: -- and prr.element_type_id = p_element_type_id

Line 972: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)

968: RUN_RESULT_ID,
969: RESULT_VALUE)
970: select /*+ INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)
971: INDEX(PRR PAY_RUN_RESULTS_N50)
972: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
973: INDEX(PIV PAY_INPUT_VALUES_F_N50) */
974: piv.input_value_id,
975: prr.run_result_id,
976: null

Line 979: pay_payroll_actions ppa,

975: prr.run_result_id,
976: null
977: from pay_assignment_actions paa,
978: pay_run_results prr,
979: pay_payroll_actions ppa,
980: pay_input_values_f piv
981: where paa.assignment_id = p_assignment_id
982: and prr.assignment_action_id = paa.assignment_action_id
983: and prr.element_type_id = p_element_type_id

Line 1306: l_effective_date pay_payroll_actions.effective_date%TYPE;

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

Line 1316: pay_payroll_actions ppa

1312: cursor csr_pre_tax is
1313: select ppt.*, ppa.effective_date
1314: from pay_jp_pre_tax_old ppt,
1315: pay_assignment_actions paa,
1316: pay_payroll_actions ppa
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

Line 1671: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;

1667: -- |-------------------------------------------------------------------|
1668: procedure validate_itw_archive(p_valid_upgrade out nocopy varchar2)
1669: is
1670: c_proc constant varchar2(61) := c_package || 'validate_itw_archive';
1671: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
1672: l_payroll_id number;
1673: l_itax_organization_id number;
1674: l_include_terminated_flag varchar2(1);
1675: l_termination_date_from date;

Line 1690: from pay_payroll_actions ppa

1686: cursor csr_pacts is
1687: select payroll_action_id,
1688: effective_date,
1689: legislative_parameters
1690: from pay_payroll_actions ppa
1691: where ppa.action_type = 'X'
1692: and ppa.report_type = 'JPTW'
1693: and ppa.report_qualifier = 'JP'
1694: and ppa.report_category = 'ARCHIVE'

Line 1762: update pay_payroll_actions

1758: --
1759: hr_utility.trace('payroll_action_id: ' || l_pact.payroll_action_id);
1760: hr_utility.trace('legislative_parameters: ' || l_legislative_parameters);
1761: --
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(

Line 1806: pay_payroll_actions ppa

1802: from dual
1803: where exists(
1804: select null
1805: from pay_assignment_actions paa,
1806: pay_payroll_actions ppa
1807: where paa.assignment_id = p_assignment_id
1808: and paa.action_status = 'C'
1809: and ppa.payroll_action_id = paa.payroll_action_id
1810: and ppa.action_type = 'X'

Line 1885: pay_payroll_actions ppa,

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