APPS.HR_LEGISLATION dependencies on PER_ASSIGNMENT_STATUS_TYPES_TL

Line 6874: -- PER_ASSIGNMENT_STATUS_TYPES_TL

6870: -- PAY_ELEMENT_CLASSIFICATIONS_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:

Line 7520: -- Seeds the PER_ASSIGNMENT_STATUS_TYPES_TL table.

7516:
7517: PROCEDURE install_pastt
7518: ----------------------
7519: IS
7520: -- Seeds the PER_ASSIGNMENT_STATUS_TYPES_TL table.
7521:
7522: CURSOR c_input_values IS
7523: select
7524: M.ASSIGNMENT_STATUS_TYPE_ID,

Line 7541: from per_assignment_status_types_tl past

7537: and B.INSTALLED_FLAG = 'B'
7538: and NVL(TO_CHAR(M.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7539: and not exists (
7540: select '1'
7541: from per_assignment_status_types_tl past
7542: where past.assignment_status_type_id =
7543: m.assignment_status_type_id
7544: and past.language = l.language_code);
7545:

Line 7555: insert into PER_ASSIGNMENT_STATUS_TYPES_TL

7551: FOR l_rec IN c_input_values LOOP
7552:
7553: -- Insert all selected rows into the TL table.
7554: -- If the row exist in the TL table then it will be ignored.
7555: insert into PER_ASSIGNMENT_STATUS_TYPES_TL
7556: (
7557: ASSIGNMENT_STATUS_TYPE_ID,
7558: LANGUAGE,
7559: SOURCE_LANG,

Line 7580: from per_assignment_status_types_tl past

7576: l_rec.CREATION_DATE
7577: from dual
7578: where not exists (
7579: select '1'
7580: from per_assignment_status_types_tl past
7581: where past.assignment_status_type_id =
7582: l_rec.assignment_status_type_id
7583: and past.language = l_rec.trans_lang);
7584: