APPS.HR_LEGISLATION dependencies on PAY_BALANCE_TYPES_TL

Line 6619: -- PAY_BALANCE_TYPES_TL

6615: ---------------------
6616: IS
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

Line 6633: -- Seeds the PAY_BALANCE_TYPES_TL table.

6629:
6630: PROCEDURE install_pbtt
6631: ----------------------
6632: IS
6633: -- Seeds the PAY_BALANCE_TYPES_TL table.
6634:
6635: CURSOR c_input_values IS
6636: select
6637: BT.BALANCE_TYPE_ID,

Line 6656: from pay_balance_types_tl btt

6652: and NVL(TO_CHAR(BT.BUSINESS_GROUP_ID),'Null Value')='Null Value'
6653: and (
6654: not exists (
6655: select '1'
6656: from pay_balance_types_tl btt
6657: where btt.balance_type_id = bt.balance_type_id
6658: and btt.language = l.language_code)
6659: or exists (select '1' from pay_balance_types_tl btt2
6660: where btt2.balance_type_id = bt.balance_type_id

Line 6659: or exists (select '1' from pay_balance_types_tl btt2

6655: select '1'
6656: from pay_balance_types_tl btt
6657: where btt.balance_type_id = bt.balance_type_id
6658: and btt.language = l.language_code)
6659: or exists (select '1' from pay_balance_types_tl btt2
6660: where btt2.balance_type_id = bt.balance_type_id
6661: and btt2.language = b.language_code
6662: and nvl(btt2.reporting_name,'XXX') <>
6663: nvl(bt.reporting_name,'XXX'))

Line 6677: delete PAY_BALANCE_TYPES_TL

6673: -- If reporting name for installed lang has changed then remove it
6674: -- before inserting updated reporting name for that installed lang
6675: -- Bug 3280179
6676:
6677: delete PAY_BALANCE_TYPES_TL
6678: where rowid in (select pbttl.rowid
6679: from pay_balance_types pbt,
6680: pay_balance_types_tl pbttl
6681: where pbt.balance_type_id = pbttl.balance_type_id

Line 6680: pay_balance_types_tl pbttl

6676:
6677: delete PAY_BALANCE_TYPES_TL
6678: where rowid in (select pbttl.rowid
6679: from pay_balance_types pbt,
6680: pay_balance_types_tl pbttl
6681: where pbt.balance_type_id = pbttl.balance_type_id
6682: and nvl(pbt.reporting_name, 'XXX') <>
6683: nvl(pbttl.reporting_name, 'XXX')
6684: and NVL(TO_CHAR(PBT.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 6690: insert into PAY_BALANCE_TYPES_TL

6686: and pbttl.language = l_rec.trans_lang);
6687:
6688: -- Insert all selected rows into the TL table.
6689: -- If the row exist in the TL table then it will be ignored.
6690: insert into PAY_BALANCE_TYPES_TL
6691: (
6692: BALANCE_TYPE_ID,
6693: LANGUAGE,
6694: SOURCE_LANG,

Line 6717: from pay_balance_types_tl btt

6713: l_rec.CREATION_DATE
6714: from dual
6715: where not exists (
6716: select '1'
6717: from pay_balance_types_tl btt
6718: where btt.balance_type_id = l_rec.balance_type_id
6719: and btt.language = l_rec.trans_lang);
6720:
6721: l_counter := l_counter + 1;