APPS.HR_LEGISLATION dependencies on PAY_INPUT_VALUES_F_TL

Line 6622: -- PAY_INPUT_VALUES_F_TL

6618: -- They are:
6619: -- PAY_BALANCE_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

Line 6985: -- Seeds the PAY_INPUT_VALUES_F_TL table.

6981:
6982: PROCEDURE install_pivft
6983: -----------------------
6984: IS
6985: -- Seeds the PAY_INPUT_VALUES_F_TL table.
6986:
6987: CURSOR c_input_values IS
6988: select
6989: IV.INPUT_VALUE_ID,

Line 7006: from PAY_INPUT_VALUES_F_TL IVT

7002: and B.INSTALLED_FLAG = 'B'
7003: and NVL(TO_CHAR(IV.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7004: and not exists (
7005: select '1'
7006: from PAY_INPUT_VALUES_F_TL IVT
7007: where IVT.INPUT_VALUE_ID = IV.INPUT_VALUE_ID
7008: and IVT.language = l.language_code);
7009:
7010: l_counter NUMBER(3) := 0;

Line 7035: insert into PAY_INPUT_VALUES_F_TL

7031: l_translated_value:=l_rec.NAME;
7032: end if;
7033: -- Insert all selected rows into the TL table.
7034: -- If the row exist in the TL table then it will be ignored.
7035: insert into PAY_INPUT_VALUES_F_TL
7036: (
7037: INPUT_VALUE_ID,
7038: NAME,
7039: LANGUAGE,

Line 7060: from PAY_INPUT_VALUES_F_TL IVT

7056: l_rec.CREATION_DATE
7057: from dual
7058: where not exists (
7059: select '1'
7060: from PAY_INPUT_VALUES_F_TL IVT
7061: where IVT.INPUT_VALUE_ID = l_rec.INPUT_VALUE_ID
7062: and IVT.language = l_rec.trans_lang);
7063:
7064: l_counter := l_counter + 1;