APPS.HR_LEGISLATION dependencies on PAY_BALANCE_CATEGORIES_F_TL

Line 6627: -- PAY_BALANCE_CATEGORIES_F_TL

6623: -- PAY_PAYMENT_TYPES_TL
6624: -- PER_ASSIGNMENT_STATUS_TYPES_TL
6625: -- PER_ASSIGNMENT_INFO_TYPES_TL
6626: -- PAY_MONETARY_UNITS_TL
6627: -- PAY_BALANCE_CATEGORIES_F_TL
6628:
6629:
6630: PROCEDURE install_pbtt
6631: ----------------------

Line 7447: -- Seeds the PAY_BALANCE_CATEGORIES_F_TL table.

7443: --
7444: PROCEDURE install_pbct
7445: ----------------------
7446: IS
7447: -- Seeds the PAY_BALANCE_CATEGORIES_F_TL table.
7448:
7449: CURSOR c_balance_categories IS
7450: select
7451: bc.BALANCE_CATEGORY_ID,

Line 7467: from PAY_BALANCE_CATEGORIES_F_TL bct

7463: where L.INSTALLED_FLAG in ('I', 'B')
7464: and B.INSTALLED_FLAG = 'B'
7465: and not exists (
7466: select '1'
7467: from PAY_BALANCE_CATEGORIES_F_TL bct
7468: where bct.BALANCE_CATEGORY_ID = bc.BALANCE_CATEGORY_ID
7469: and bct.language = l.language_code);
7470:
7471: l_counter NUMBER(3) := 0;

Line 7480: insert into PAY_BALANCE_CATEGORIES_F_TL

7476: FOR l_rec IN c_balance_categories LOOP
7477:
7478: -- Insert all selected rows into the TL table.
7479: -- If the row exist in the TL table then it will be ignored.
7480: insert into PAY_BALANCE_CATEGORIES_F_TL
7481: (
7482: BALANCE_CATEGORY_ID,
7483: LANGUAGE,
7484: SOURCE_LANG,

Line 7505: from PAY_BALANCE_CATEGORIES_F_TL bct

7501: l_rec.CREATION_DATE
7502: from dual
7503: where not exists (
7504: select '1'
7505: from PAY_BALANCE_CATEGORIES_F_TL bct
7506: where bct.BALANCE_CATEGORY_ID = l_rec.BALANCE_CATEGORY_ID
7507: and bct.language = l_rec.trans_lang);
7508:
7509: l_counter := l_counter + 1;