APPS.HR_LEGISLATION dependencies on PER_ASSIGNMENT_INFO_TYPES_TL

Line 6625: -- PER_ASSIGNMENT_INFO_TYPES_TL

6621: -- PAY_ELEMENT_TYPES_F_TL
6622: -- PAY_INPUT_VALUES_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:

Line 7181: -- Seeds the PER_ASSIGNMENT_INFO_TYPES_TL table.

7177:
7178: PROCEDURE install_paitt
7179: ----------------------
7180: IS
7181: -- Seeds the PER_ASSIGNMENT_INFO_TYPES_TL table.
7182:
7183: CURSOR c_input_values IS
7184: select
7185: M.INFORMATION_TYPE,

Line 7200: from per_assignment_info_types_tl pait

7196: FND_LANGUAGES B
7197: where L.INSTALLED_FLAG in ('I', 'B')
7198: and B.INSTALLED_FLAG = 'B'
7199: and not exists ( select '1'
7200: from per_assignment_info_types_tl pait
7201: where pait.information_type = m.information_type
7202: and pait.language = l.language_code);
7203:
7204: l_counter NUMBER(3) := 0;

Line 7213: insert into PER_ASSIGNMENT_INFO_TYPES_TL

7209: FOR l_rec IN c_input_values LOOP
7210:
7211: -- Insert all selected rows into the TL table.
7212: -- If the row exist in the TL table then it will be ignored.
7213: insert into PER_ASSIGNMENT_INFO_TYPES_TL
7214: (
7215: INFORMATION_TYPE,
7216: LANGUAGE,
7217: SOURCE_LANG,

Line 7237: from per_assignment_info_types_tl pait

7233: l_rec.CREATED_BY,
7234: l_rec.CREATION_DATE
7235: from dual
7236: where not exists ( select '1'
7237: from per_assignment_info_types_tl pait
7238: where pait.information_type =
7239: l_rec.information_type
7240: and pait.language = l_rec.trans_lang);
7241: