APPS.HR_LEGISLATION dependencies on PER_ASSIGNMENT_STATUS_TYPES_TL

Line 6624: -- PER_ASSIGNMENT_STATUS_TYPES_TL

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

Line 7270: -- Seeds the PER_ASSIGNMENT_STATUS_TYPES_TL table.

7266:
7267: PROCEDURE install_pastt
7268: ----------------------
7269: IS
7270: -- Seeds the PER_ASSIGNMENT_STATUS_TYPES_TL table.
7271:
7272: CURSOR c_input_values IS
7273: select
7274: M.ASSIGNMENT_STATUS_TYPE_ID,

Line 7291: from per_assignment_status_types_tl past

7287: and B.INSTALLED_FLAG = 'B'
7288: and NVL(TO_CHAR(M.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7289: and not exists (
7290: select '1'
7291: from per_assignment_status_types_tl past
7292: where past.assignment_status_type_id =
7293: m.assignment_status_type_id
7294: and past.language = l.language_code);
7295:

Line 7305: insert into PER_ASSIGNMENT_STATUS_TYPES_TL

7301: FOR l_rec IN c_input_values LOOP
7302:
7303: -- Insert all selected rows into the TL table.
7304: -- If the row exist in the TL table then it will be ignored.
7305: insert into PER_ASSIGNMENT_STATUS_TYPES_TL
7306: (
7307: ASSIGNMENT_STATUS_TYPE_ID,
7308: LANGUAGE,
7309: SOURCE_LANG,

Line 7330: from per_assignment_status_types_tl past

7326: l_rec.CREATION_DATE
7327: from dual
7328: where not exists (
7329: select '1'
7330: from per_assignment_status_types_tl past
7331: where past.assignment_status_type_id =
7332: l_rec.assignment_status_type_id
7333: and past.language = l_rec.trans_lang);
7334: