APPS.HR_LEGISLATION dependencies on PAY_INPUT_VALUES_F_TL

Line 6872: -- PAY_INPUT_VALUES_F_TL

6868: -- They are:
6869: -- PAY_BALANCE_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

Line 7235: -- Seeds the PAY_INPUT_VALUES_F_TL table.

7231:
7232: PROCEDURE install_pivft
7233: -----------------------
7234: IS
7235: -- Seeds the PAY_INPUT_VALUES_F_TL table.
7236:
7237: CURSOR c_input_values IS
7238: select
7239: IV.INPUT_VALUE_ID,

Line 7256: from PAY_INPUT_VALUES_F_TL IVT

7252: and B.INSTALLED_FLAG = 'B'
7253: and NVL(TO_CHAR(IV.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7254: and not exists (
7255: select '1'
7256: from PAY_INPUT_VALUES_F_TL IVT
7257: where IVT.INPUT_VALUE_ID = IV.INPUT_VALUE_ID
7258: and IVT.language = l.language_code);
7259:
7260: l_counter NUMBER(3) := 0;

Line 7285: insert into PAY_INPUT_VALUES_F_TL

7281: l_translated_value:=l_rec.NAME;
7282: end if;
7283: -- Insert all selected rows into the TL table.
7284: -- If the row exist in the TL table then it will be ignored.
7285: insert into PAY_INPUT_VALUES_F_TL
7286: (
7287: INPUT_VALUE_ID,
7288: NAME,
7289: LANGUAGE,

Line 7310: from PAY_INPUT_VALUES_F_TL IVT

7306: l_rec.CREATION_DATE
7307: from dual
7308: where not exists (
7309: select '1'
7310: from PAY_INPUT_VALUES_F_TL IVT
7311: where IVT.INPUT_VALUE_ID = l_rec.INPUT_VALUE_ID
7312: and IVT.language = l_rec.trans_lang);
7313:
7314: l_counter := l_counter + 1;