[Home] [Help]
303: -- 115.95.11510.3 DVickers 18-JUL-2003 insert category_name if
304: -- user_category_name is null
305: -- 115.96 Scchakra 16-JUL-2003 Bug 2982582. Added code in install_att
306: -- to install startup data in table
307: -- pay_monetary_units_tl.
308: -- 115.97 DVickers 30-SEP-2003 Added distinct to create_zz_leg_rule
309: -- 115.98 DVickers 02-OCT-2003 Added 4 new cols to
310: -- HR_S_LEGISLATIVE_FIELD_INFO
311: -- 115.99 DVickers 02-SEP-2003 Added CATEGORY as well
6872: -- PAY_INPUT_VALUES_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
7605: --
7606: PROCEDURE install_pmut
7607: ----------------------
7608: IS
7609: -- Seeds the PAY_MONETARY_UNITS_TL table.
7610:
7611: CURSOR c_monetary_units IS
7612: select
7613: M.MONETARY_UNIT_ID,
7626: and B.INSTALLED_FLAG = 'B'
7627: and NVL(TO_CHAR(M.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7628: and not exists (
7629: select '1'
7630: from PAY_MONETARY_UNITS_TL pmut
7631: where pmut.monetary_unit_id =
7632: m.monetary_unit_id
7633: and pmut.language = l.language_code);
7634:
7640: FOR l_rec IN c_monetary_units LOOP
7641:
7642: -- Insert all selected rows into the TL table.
7643: -- If the row exist in the TL table then it will be ignored.
7644: insert into PAY_MONETARY_UNITS_TL
7645: (
7646: MONETARY_UNIT_ID,
7647: LANGUAGE,
7648: SOURCE_LANG,
7665: l_rec.CREATION_DATE
7666: from dual
7667: where not exists (
7668: select '1'
7669: from PAY_MONETARY_UNITS_TL pmut
7670: where pmut.monetary_unit_id =
7671: l_rec.monetary_unit_id
7672: and pmut.language = l_rec.trans_lang);
7673: