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.HR_LEGISLATION dependencies on PAY_ELEMENT_TYPES_F

Line 6621: -- PAY_ELEMENT_TYPES_F_TL

6617: -- Install all startup data for multilingual tables.
6618: -- They are:
6619: -- PAY_BALANCE_TYPES_TL
6620: -- PAY_ELEMENT_CLASSIFICATIONS_TL
6621: -- PAY_ELEMENT_TYPES_F_TL
6622: -- PAY_INPUT_VALUES_F_TL
6623: -- PAY_PAYMENT_TYPES_TL
6624: -- PER_ASSIGNMENT_STATUS_TYPES_TL
6625: -- PER_ASSIGNMENT_INFO_TYPES_TL

Line 6860: -- Seeds the PAY_ELEMENT_TYPES_F_TL table.

6856:
6857: PROCEDURE install_petft
6858: ----------------------
6859: IS
6860: -- Seeds the PAY_ELEMENT_TYPES_F_TL table.
6861:
6862: CURSOR c_input_values IS
6863: select
6864: ET.ELEMENT_TYPE_ID,

Line 6875: from PAY_ELEMENT_TYPES_F ET,

6871: ET.LAST_UPDATED_BY,
6872: ET.LAST_UPDATE_LOGIN,
6873: ET.CREATED_BY,
6874: ET.CREATION_DATE
6875: from PAY_ELEMENT_TYPES_F ET,
6876: FND_LANGUAGES L,
6877: FND_LANGUAGES B
6878: where L.INSTALLED_FLAG in ('I', 'B')
6879: and B.INSTALLED_FLAG = 'B'

Line 6884: from PAY_ELEMENT_TYPES_F_TL ETT

6880: and NVL(TO_CHAR(ET.BUSINESS_GROUP_ID),'Null Value')='Null Value'
6881: and
6882: ( not exists (
6883: select '1'
6884: from PAY_ELEMENT_TYPES_F_TL ETT
6885: where ETT.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID
6886: and ETT.language = l.language_code)
6887: or exists (select '1' from PAY_ELEMENT_TYPES_F_TL ett2
6888: where ett2.ELEMENT_TYPE_ID = et.ELEMENT_TYPE_ID

Line 6887: or exists (select '1' from PAY_ELEMENT_TYPES_F_TL ett2

6883: select '1'
6884: from PAY_ELEMENT_TYPES_F_TL ETT
6885: where ETT.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID
6886: and ETT.language = l.language_code)
6887: or exists (select '1' from PAY_ELEMENT_TYPES_F_TL ett2
6888: where ett2.ELEMENT_TYPE_ID = et.ELEMENT_TYPE_ID
6889: and ett2.language = b.language_code
6890: and (nvl(ett2.reporting_name, 'XXX') <> nvl(et.reporting_name, 'XXX')
6891: or

Line 6906: delete PAY_ELEMENT_TYPES_F_TL

6902: -- has changed then remove it before inserting updated
6903: -- value for that installed lang
6904: -- Bug 3280179
6905:
6906: delete PAY_ELEMENT_TYPES_F_TL
6907: where rowid in (select pettl.rowid
6908: from pay_element_types_f pet,
6909: pay_element_types_f_tl pettl
6910: where pet.element_type_id = pettl.element_type_id

Line 6908: from pay_element_types_f pet,

6904: -- Bug 3280179
6905:
6906: delete PAY_ELEMENT_TYPES_F_TL
6907: where rowid in (select pettl.rowid
6908: from pay_element_types_f pet,
6909: pay_element_types_f_tl pettl
6910: where pet.element_type_id = pettl.element_type_id
6911: and (
6912: (nvl(pet.reporting_name, 'XXX') <>

Line 6909: pay_element_types_f_tl pettl

6905:
6906: delete PAY_ELEMENT_TYPES_F_TL
6907: where rowid in (select pettl.rowid
6908: from pay_element_types_f pet,
6909: pay_element_types_f_tl pettl
6910: where pet.element_type_id = pettl.element_type_id
6911: and (
6912: (nvl(pet.reporting_name, 'XXX') <>
6913: nvl(pettl.reporting_name, 'XXX'))

Line 6925: insert into PAY_ELEMENT_TYPES_F_TL

6921:
6922: -- Insert all selected rows into the TL table.
6923: -- If the row exist in the TL table then it will be ignored.
6924:
6925: insert into PAY_ELEMENT_TYPES_F_TL
6926: (
6927: ELEMENT_TYPE_ID,
6928: ELEMENT_NAME,
6929: REPORTING_NAME,

Line 6954: from PAY_ELEMENT_TYPES_F_TL ETT

6950: l_rec.CREATION_DATE
6951: from dual
6952: where not exists (
6953: select '1'
6954: from PAY_ELEMENT_TYPES_F_TL ETT
6955: where ETT.ELEMENT_TYPE_ID = l_rec.ELEMENT_TYPE_ID
6956: and ETT.language = l_rec.trans_lang);
6957:
6958: l_counter := l_counter + 1;