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 557: if l_table_name = 'PAY_ELEMENT_TYPES_F' then

553: hr_utility.set_location('P_ADDL_SURROGATE_KEY_NAME2 '||P_ADDL_SURROGATE_KEY_NAME2,10);
554: hr_utility.set_location('p_effective_date '||p_effective_date,10);
555: end if;
556:
557: if l_table_name = 'PAY_ELEMENT_TYPES_F' then
558:
559: Select 'Y' into v_exists from dual where exists (
560: select null
561: from pay_element_types_f et

Line 561: from pay_element_types_f et

557: if l_table_name = 'PAY_ELEMENT_TYPES_F' then
558:
559: Select 'Y' into v_exists from dual where exists (
560: select null
561: from pay_element_types_f et
562: where et.business_group_id is null
563: and et.legislation_code = p_legislation_code
564: and et.created_by > 2
565: and et.last_updated_by > 2

Line 584: pay_element_types_f et

580:
581: Select 'Y' into v_exists from dual where exists(
582: select null
583: from pay_input_values_f iv,
584: pay_element_types_f et
585: where et.element_type_id = iv.element_type_id
586: and iv.business_group_id is null
587: and iv.legislation_code = p_legislation_code
588: and p_effective_date <= iv.effective_end_date

Line 654: pay_element_types_f et,

650:
651: Select 'Y' into v_exists from dual where exists(
652: select null
653: from PAY_STATUS_PROCESSING_RULES_F spr,
654: pay_element_types_f et,
655: per_assignment_status_types ast
656: where spr.business_group_id is null
657: and spr.element_type_id = et.element_type_id
658: and ast.ASSIGNMENT_STATUS_TYPE_ID = spr.ASSIGNMENT_STATUS_TYPE_ID

Line 6871: -- PAY_ELEMENT_TYPES_F_TL

6867: -- Install all startup data for multilingual tables.
6868: -- They are:
6869: -- PAY_BALANCE_TYPES_TL
6870: -- PAY_ELEMENT_CLASSIFICATIONS_TL
6871: -- PAY_ELEMENT_TYPES_F_TL
6872: -- PAY_INPUT_VALUES_F_TL
6873: -- PAY_PAYMENT_TYPES_TL
6874: -- PER_ASSIGNMENT_STATUS_TYPES_TL
6875: -- PER_ASSIGNMENT_INFO_TYPES_TL

Line 7110: -- Seeds the PAY_ELEMENT_TYPES_F_TL table.

7106:
7107: PROCEDURE install_petft
7108: ----------------------
7109: IS
7110: -- Seeds the PAY_ELEMENT_TYPES_F_TL table.
7111:
7112: CURSOR c_input_values IS
7113: select
7114: ET.ELEMENT_TYPE_ID,

Line 7125: from PAY_ELEMENT_TYPES_F ET,

7121: ET.LAST_UPDATED_BY,
7122: ET.LAST_UPDATE_LOGIN,
7123: ET.CREATED_BY,
7124: ET.CREATION_DATE
7125: from PAY_ELEMENT_TYPES_F ET,
7126: FND_LANGUAGES L,
7127: FND_LANGUAGES B
7128: where L.INSTALLED_FLAG in ('I', 'B')
7129: and B.INSTALLED_FLAG = 'B'

Line 7134: from PAY_ELEMENT_TYPES_F_TL ETT

7130: and NVL(TO_CHAR(ET.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7131: and
7132: ( not exists (
7133: select '1'
7134: from PAY_ELEMENT_TYPES_F_TL ETT
7135: where ETT.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID
7136: and ETT.language = l.language_code)
7137: or exists (select '1' from PAY_ELEMENT_TYPES_F_TL ett2
7138: where ett2.ELEMENT_TYPE_ID = et.ELEMENT_TYPE_ID

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

7133: select '1'
7134: from PAY_ELEMENT_TYPES_F_TL ETT
7135: where ETT.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID
7136: and ETT.language = l.language_code)
7137: or exists (select '1' from PAY_ELEMENT_TYPES_F_TL ett2
7138: where ett2.ELEMENT_TYPE_ID = et.ELEMENT_TYPE_ID
7139: and ett2.language = b.language_code
7140: and (nvl(ett2.reporting_name, 'XXX') <> nvl(et.reporting_name, 'XXX')
7141: or

Line 7156: delete PAY_ELEMENT_TYPES_F_TL

7152: -- has changed then remove it before inserting updated
7153: -- value for that installed lang
7154: -- Bug 3280179
7155:
7156: delete PAY_ELEMENT_TYPES_F_TL
7157: where rowid in (select pettl.rowid
7158: from pay_element_types_f pet,
7159: pay_element_types_f_tl pettl
7160: where pet.element_type_id = pettl.element_type_id

Line 7158: from pay_element_types_f pet,

7154: -- Bug 3280179
7155:
7156: delete PAY_ELEMENT_TYPES_F_TL
7157: where rowid in (select pettl.rowid
7158: from pay_element_types_f pet,
7159: pay_element_types_f_tl pettl
7160: where pet.element_type_id = pettl.element_type_id
7161: and (
7162: (nvl(pet.reporting_name, 'XXX') <>

Line 7159: pay_element_types_f_tl pettl

7155:
7156: delete PAY_ELEMENT_TYPES_F_TL
7157: where rowid in (select pettl.rowid
7158: from pay_element_types_f pet,
7159: pay_element_types_f_tl pettl
7160: where pet.element_type_id = pettl.element_type_id
7161: and (
7162: (nvl(pet.reporting_name, 'XXX') <>
7163: nvl(pettl.reporting_name, 'XXX'))

Line 7175: insert into PAY_ELEMENT_TYPES_F_TL

7171:
7172: -- Insert all selected rows into the TL table.
7173: -- If the row exist in the TL table then it will be ignored.
7174:
7175: insert into PAY_ELEMENT_TYPES_F_TL
7176: (
7177: ELEMENT_TYPE_ID,
7178: ELEMENT_NAME,
7179: REPORTING_NAME,

Line 7204: from PAY_ELEMENT_TYPES_F_TL ETT

7200: l_rec.CREATION_DATE
7201: from dual
7202: where not exists (
7203: select '1'
7204: from PAY_ELEMENT_TYPES_F_TL ETT
7205: where ETT.ELEMENT_TYPE_ID = l_rec.ELEMENT_TYPE_ID
7206: and ETT.language = l_rec.trans_lang);
7207:
7208: l_counter := l_counter + 1;