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_ELEMENT_LINKS_F

Line 270: pay_element_links_f pel,

266: from dual
267: where exists(
268: select null
269: from pay_element_types_f pet,
270: pay_element_links_f pel,
271: pay_element_entries_f pee
272: where pet.element_name = 'YEA_PREV_EMP_INFO'
273: and pet.legislation_code = 'JP'
274: and pel.element_type_id = pet.element_type_id

Line 304: pay_element_links_f pel,

300: from dual
301: where exists(
302: select null
303: from pay_element_types_f pet,
304: pay_element_links_f pel,
305: pay_element_entries_f pee
306: where pet.element_name = 'YEA_PREV_EMP_INFO'
307: and pet.legislation_code = 'JP'
308: and pel.element_type_id = pet.element_type_id

Line 367: pay_element_links_f pel,

363: min(decode(piv.display_sequence, 8, peev.screen_entry_value)) employer_address,
364: hr_jp_standard_pkg.to_hankaku(min(decode(piv.display_sequence, 9, peev.screen_entry_value))) employer_name_kana,
365: min(decode(piv.display_sequence, 10, peev.screen_entry_value)) employer_name
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'

Line 595: INDEX(PEL PAY_ELEMENT_LINKS_F_FK11)

591: where exists(
592: select /*+ ORDERED
593: NO_MERGE(BG)
594: USE_NL(PEL PEE)
595: INDEX(PEL PAY_ELEMENT_LINKS_F_FK11)
596: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N4) */
597: null
598: from per_business_groups_perf bg,
599: pay_element_links_f pel,

Line 599: pay_element_links_f pel,

595: INDEX(PEL PAY_ELEMENT_LINKS_F_FK11)
596: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N4) */
597: null
598: from per_business_groups_perf bg,
599: pay_element_links_f pel,
600: pay_element_entries_f pee
601: where bg.legislation_code = p_legislation_code
602: and pel.business_group_id = bg.business_group_id
603: and pee.element_link_id = pel.element_link_id)

Line 651: INDEX(PEL PAY_ELEMENT_LINKS_F_N7)

647: from dual
648: where exists(
649: select /*+ ORDERED
650: USE_NL(PEE)
651: INDEX(PEL PAY_ELEMENT_LINKS_F_N7)
652: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N4) */
653: null
654: from pay_element_links_f pel,
655: pay_element_entries_f pee

Line 654: from pay_element_links_f pel,

650: USE_NL(PEE)
651: INDEX(PEL PAY_ELEMENT_LINKS_F_N7)
652: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N4) */
653: null
654: from pay_element_links_f pel,
655: pay_element_entries_f pee
656: where pel.element_type_id = p_element_type_id
657: and pee.element_link_id = pel.element_link_id)
658: or exists(

Line 733: INDEX(PEL PAY_ELEMENT_LINKS_F_N7)

729: from dual
730: where exists(
731: select /*+ ORDERED
732: USE_NL(PEE)
733: INDEX(PEL PAY_ELEMENT_LINKS_F_N7)
734: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
735: null
736: from pay_element_links_f pel,
737: pay_element_entries_f pee

Line 736: from pay_element_links_f pel,

732: USE_NL(PEE)
733: INDEX(PEL PAY_ELEMENT_LINKS_F_N7)
734: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
735: null
736: from pay_element_links_f pel,
737: pay_element_entries_f pee
738: where pel.element_type_id = p_element_type_id
739: and pee.assignment_id = p_assignment_id
740: and pee.element_link_id = pel.element_link_id)

Line 785: from pay_element_links_f pel,

781: select pel.element_link_id,
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

Line 865: pay_element_links_f pel,

861: pliv.input_value_id,
862: pee.element_entry_id,
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