APPS.HR_LEGISLATION dependencies on PAY_PAYMENT_TYPES_TL

Line 6623: -- PAY_PAYMENT_TYPES_TL

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
6627: -- PAY_BALANCE_CATEGORIES_F_TL

Line 7088: -- Seeds the PAY_PAYMENT_TYPES_TL table.

7084:
7085: PROCEDURE install_pptt
7086: ----------------------
7087: IS
7088: -- Seeds the PAY_PAYMENT_TYPES_TL table.
7089:
7090: CURSOR c_input_values IS
7091: select
7092: PT.PAYMENT_TYPE_ID,

Line 7109: from PAY_PAYMENT_TYPES_TL PTT

7105: where L.INSTALLED_FLAG in ('I', 'B')
7106: and B.INSTALLED_FLAG = 'B'
7107: and not exists (
7108: select '1'
7109: from PAY_PAYMENT_TYPES_TL PTT
7110: where PTT.PAYMENT_TYPE_ID = PT.PAYMENT_TYPE_ID
7111: and PTT.language = l.language_code);
7112:
7113: l_counter NUMBER(3) := 0;

Line 7122: insert into PAY_PAYMENT_TYPES_TL

7118: FOR l_rec IN c_input_values LOOP
7119:
7120: -- Insert all selected rows into the TL table.
7121: -- If the row exist in the TL table then it will be ignored.
7122: insert into PAY_PAYMENT_TYPES_TL
7123: (
7124: PAYMENT_TYPE_ID,
7125: PAYMENT_TYPE_NAME,
7126: DESCRIPTION,

Line 7149: from PAY_PAYMENT_TYPES_TL PTT

7145: l_rec.CREATION_DATE
7146: from dual
7147: where not exists (
7148: select '1'
7149: from PAY_PAYMENT_TYPES_TL PTT
7150: where PTT.PAYMENT_TYPE_ID = l_rec.PAYMENT_TYPE_ID
7151: and PTT.language = l_rec.trans_lang);
7152:
7153: l_counter := l_counter + 1;