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_INPUT_VALUES_F

Line 370: pay_input_values_f piv

366: from pay_element_types_f pet,
367: pay_element_links_f pel,
368: pay_element_entries_f pee,
369: pay_element_entry_values_f peev,
370: pay_input_values_f piv
371: where pet.element_name = 'YEA_PREV_EMP_INFO'
372: and pet.legislation_code = 'JP'
373: and pel.element_type_id = pet.element_type_id
374: and pel.business_group_id + 0 = l_business_group_id

Line 786: pay_input_values_f piv

782: piv.input_value_id,
783: min(pel.effective_start_date) effective_start_date,
784: max(pel.effective_end_date) effective_end_date
785: from pay_element_links_f pel,
786: pay_input_values_f piv
787: where pel.element_type_id = p_element_type_id
788: and piv.element_type_id = pel.element_type_id
789: and pel.effective_start_date
790: between piv.effective_start_date and piv.effective_end_date

Line 867: pay_input_values_f piv

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
871: between pel.effective_start_date and pel.effective_end_date

Line 930: -- INDEX(PIV PAY_INPUT_VALUES_F_N50) */

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
934: -- from pay_assignment_actions paa,

Line 937: -- pay_input_values_f piv

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
941: -- and prr.source_type in ('E', 'R')

Line 967: INDEX(PIV PAY_INPUT_VALUES_F_N50) */

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
971: from pay_assignment_actions paa,

Line 974: pay_input_values_f piv

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
978: and ppa.payroll_action_id = paa.payroll_action_id