APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 271: pay_element_entries_f pee

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
275: and pee.element_link_id = pel.element_link_id);

Line 305: pay_element_entries_f pee

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
309: and pee.assignment_id = p_assignment_id

Line 368: pay_element_entries_f pee,

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'
372: and pet.legislation_code = 'JP'

Line 596: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N4) */

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,
600: pay_element_entries_f pee

Line 600: pay_element_entries_f pee

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)
604: or exists(

Line 652: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N4) */

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
656: where pel.element_type_id = p_element_type_id

Line 655: pay_element_entries_f 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(
659: select null

Line 692: from pay_element_entries_f pee

688: select 'Y'
689: from dual
690: where exists(
691: select null -- Removed the Hint Bug# 4674234
692: from pay_element_entries_f pee
693: where pee.assignment_id = p_assignment_id)
694: or exists(
695: select null
696: from pay_assignment_actions paa,

Line 734: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */

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
738: where pel.element_type_id = p_element_type_id

Line 737: pay_element_entries_f 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)
741: or exists(

Line 864: from pay_element_entries_f pee,

860: pee.effective_end_date,
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