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 863: INDEX(PIV PAY_INPUT_VALUES_F_PK) */

859: USE_NL(PEL PLIV PIV)
860: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N50)
861: INDEX(PEL PAY_ELEMENT_LINKS_F_PK)
862: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_U50)
863: INDEX(PIV PAY_INPUT_VALUES_F_PK) */
864: pay_element_entry_values_s.nextval,
865: pee.effective_start_date,
866: pee.effective_end_date,
867: pliv.input_value_id,

Line 873: pay_input_values_f piv

869: decode(piv.hot_default_flag, 'Y', null, nvl(pliv.default_value, piv.default_value))
870: from pay_element_entries_f pee,
871: pay_element_links_f pel,
872: pay_link_input_values_f pliv,
873: pay_input_values_f piv
874: where pee.assignment_id = p_assignment_id
875: and pel.element_link_id = pee.element_link_id
876: and pee.effective_start_date
877: between pel.effective_start_date and pel.effective_end_date

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

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

Line 943: -- pay_input_values_f piv

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

Line 973: INDEX(PIV PAY_INPUT_VALUES_F_N50) */

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

Line 980: pay_input_values_f piv

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