APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 269: from pay_element_types_f pet,

265: select 'TRUE'
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'

Line 303: from pay_element_types_f pet,

299: select 'Y'
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'

Line 366: from pay_element_types_f pet,

362: hr_jp_standard_pkg.to_hankaku(min(decode(piv.display_sequence, 7, peev.screen_entry_value))) employer_address_kana,
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

Line 1007: from pay_element_types_f

1003: --
1004: cursor csr_id is
1005: select distinct
1006: element_type_id
1007: from pay_element_types_f
1008: where element_name = p_element_name
1009: and business_group_id is null
1010: and legislation_code = 'JP';
1011: begin