APPS.HR_LEGISLATION dependencies on PAY_BALANCE_TYPES_TL

Line 6869: -- PAY_BALANCE_TYPES_TL

6865: ---------------------
6866: IS
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

Line 6883: -- Seeds the PAY_BALANCE_TYPES_TL table.

6879:
6880: PROCEDURE install_pbtt
6881: ----------------------
6882: IS
6883: -- Seeds the PAY_BALANCE_TYPES_TL table.
6884:
6885: CURSOR c_input_values IS
6886: select
6887: BT.BALANCE_TYPE_ID,

Line 6906: from pay_balance_types_tl btt

6902: and NVL(TO_CHAR(BT.BUSINESS_GROUP_ID),'Null Value')='Null Value'
6903: and (
6904: not exists (
6905: select '1'
6906: from pay_balance_types_tl btt
6907: where btt.balance_type_id = bt.balance_type_id
6908: and btt.language = l.language_code)
6909: or exists (select '1' from pay_balance_types_tl btt2
6910: where btt2.balance_type_id = bt.balance_type_id

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

6905: select '1'
6906: from pay_balance_types_tl btt
6907: where btt.balance_type_id = bt.balance_type_id
6908: and btt.language = l.language_code)
6909: or exists (select '1' from pay_balance_types_tl btt2
6910: where btt2.balance_type_id = bt.balance_type_id
6911: and btt2.language = b.language_code
6912: and nvl(btt2.reporting_name,'XXX') <>
6913: nvl(bt.reporting_name,'XXX'))

Line 6927: delete PAY_BALANCE_TYPES_TL

6923: -- If reporting name for installed lang has changed then remove it
6924: -- before inserting updated reporting name for that installed lang
6925: -- Bug 3280179
6926:
6927: delete PAY_BALANCE_TYPES_TL
6928: where rowid in (select pbttl.rowid
6929: from pay_balance_types pbt,
6930: pay_balance_types_tl pbttl
6931: where pbt.balance_type_id = pbttl.balance_type_id

Line 6930: pay_balance_types_tl pbttl

6926:
6927: delete PAY_BALANCE_TYPES_TL
6928: where rowid in (select pbttl.rowid
6929: from pay_balance_types pbt,
6930: pay_balance_types_tl pbttl
6931: where pbt.balance_type_id = pbttl.balance_type_id
6932: and nvl(pbt.reporting_name, 'XXX') <>
6933: nvl(pbttl.reporting_name, 'XXX')
6934: and NVL(TO_CHAR(PBT.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 6940: insert into PAY_BALANCE_TYPES_TL

6936: and pbttl.language = l_rec.trans_lang);
6937:
6938: -- Insert all selected rows into the TL table.
6939: -- If the row exist in the TL table then it will be ignored.
6940: insert into PAY_BALANCE_TYPES_TL
6941: (
6942: BALANCE_TYPE_ID,
6943: LANGUAGE,
6944: SOURCE_LANG,

Line 6967: from pay_balance_types_tl btt

6963: l_rec.CREATION_DATE
6964: from dual
6965: where not exists (
6966: select '1'
6967: from pay_balance_types_tl btt
6968: where btt.balance_type_id = l_rec.balance_type_id
6969: and btt.language = l_rec.trans_lang);
6970:
6971: l_counter := l_counter + 1;