APPS.HR_LEGISLATION dependencies on PAY_BALANCE_CATEGORIES_F_TL

Line 6877: -- PAY_BALANCE_CATEGORIES_F_TL

6873: -- PAY_PAYMENT_TYPES_TL
6874: -- PER_ASSIGNMENT_STATUS_TYPES_TL
6875: -- PER_ASSIGNMENT_INFO_TYPES_TL
6876: -- PAY_MONETARY_UNITS_TL
6877: -- PAY_BALANCE_CATEGORIES_F_TL
6878:
6879:
6880: PROCEDURE install_pbtt
6881: ----------------------

Line 7697: -- Seeds the PAY_BALANCE_CATEGORIES_F_TL table.

7693: --
7694: PROCEDURE install_pbct
7695: ----------------------
7696: IS
7697: -- Seeds the PAY_BALANCE_CATEGORIES_F_TL table.
7698:
7699: CURSOR c_balance_categories IS
7700: select
7701: bc.BALANCE_CATEGORY_ID,

Line 7717: from PAY_BALANCE_CATEGORIES_F_TL bct

7713: where L.INSTALLED_FLAG in ('I', 'B')
7714: and B.INSTALLED_FLAG = 'B'
7715: and not exists (
7716: select '1'
7717: from PAY_BALANCE_CATEGORIES_F_TL bct
7718: where bct.BALANCE_CATEGORY_ID = bc.BALANCE_CATEGORY_ID
7719: and bct.language = l.language_code);
7720:
7721: l_counter NUMBER(3) := 0;

Line 7730: insert into PAY_BALANCE_CATEGORIES_F_TL

7726: FOR l_rec IN c_balance_categories LOOP
7727:
7728: -- Insert all selected rows into the TL table.
7729: -- If the row exist in the TL table then it will be ignored.
7730: insert into PAY_BALANCE_CATEGORIES_F_TL
7731: (
7732: BALANCE_CATEGORY_ID,
7733: LANGUAGE,
7734: SOURCE_LANG,

Line 7755: from PAY_BALANCE_CATEGORIES_F_TL bct

7751: l_rec.CREATION_DATE
7752: from dual
7753: where not exists (
7754: select '1'
7755: from PAY_BALANCE_CATEGORIES_F_TL bct
7756: where bct.BALANCE_CATEGORY_ID = l_rec.BALANCE_CATEGORY_ID
7757: and bct.language = l_rec.trans_lang);
7758:
7759: l_counter := l_counter + 1;