APPS.HR_LEGISLATION dependencies on PER_ASSIGNMENT_INFO_TYPES_TL

Line 6875: -- PER_ASSIGNMENT_INFO_TYPES_TL

6871: -- PAY_ELEMENT_TYPES_F_TL
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:

Line 7431: -- Seeds the PER_ASSIGNMENT_INFO_TYPES_TL table.

7427:
7428: PROCEDURE install_paitt
7429: ----------------------
7430: IS
7431: -- Seeds the PER_ASSIGNMENT_INFO_TYPES_TL table.
7432:
7433: CURSOR c_input_values IS
7434: select
7435: M.INFORMATION_TYPE,

Line 7450: from per_assignment_info_types_tl pait

7446: FND_LANGUAGES B
7447: where L.INSTALLED_FLAG in ('I', 'B')
7448: and B.INSTALLED_FLAG = 'B'
7449: and not exists ( select '1'
7450: from per_assignment_info_types_tl pait
7451: where pait.information_type = m.information_type
7452: and pait.language = l.language_code);
7453:
7454: l_counter NUMBER(3) := 0;

Line 7463: insert into PER_ASSIGNMENT_INFO_TYPES_TL

7459: FOR l_rec IN c_input_values LOOP
7460:
7461: -- Insert all selected rows into the TL table.
7462: -- If the row exist in the TL table then it will be ignored.
7463: insert into PER_ASSIGNMENT_INFO_TYPES_TL
7464: (
7465: INFORMATION_TYPE,
7466: LANGUAGE,
7467: SOURCE_LANG,

Line 7487: from per_assignment_info_types_tl pait

7483: l_rec.CREATED_BY,
7484: l_rec.CREATION_DATE
7485: from dual
7486: where not exists ( select '1'
7487: from per_assignment_info_types_tl pait
7488: where pait.information_type =
7489: l_rec.information_type
7490: and pait.language = l_rec.trans_lang);
7491: