APPS.HR_LEGISLATION dependencies on PAY_PAYMENT_TYPES_TL

Line 6873: -- PAY_PAYMENT_TYPES_TL

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

Line 7338: -- Seeds the PAY_PAYMENT_TYPES_TL table.

7334:
7335: PROCEDURE install_pptt
7336: ----------------------
7337: IS
7338: -- Seeds the PAY_PAYMENT_TYPES_TL table.
7339:
7340: CURSOR c_input_values IS
7341: select
7342: PT.PAYMENT_TYPE_ID,

Line 7359: from PAY_PAYMENT_TYPES_TL PTT

7355: where L.INSTALLED_FLAG in ('I', 'B')
7356: and B.INSTALLED_FLAG = 'B'
7357: and not exists (
7358: select '1'
7359: from PAY_PAYMENT_TYPES_TL PTT
7360: where PTT.PAYMENT_TYPE_ID = PT.PAYMENT_TYPE_ID
7361: and PTT.language = l.language_code);
7362:
7363: l_counter NUMBER(3) := 0;

Line 7372: insert into PAY_PAYMENT_TYPES_TL

7368: FOR l_rec IN c_input_values LOOP
7369:
7370: -- Insert all selected rows into the TL table.
7371: -- If the row exist in the TL table then it will be ignored.
7372: insert into PAY_PAYMENT_TYPES_TL
7373: (
7374: PAYMENT_TYPE_ID,
7375: PAYMENT_TYPE_NAME,
7376: DESCRIPTION,

Line 7399: from PAY_PAYMENT_TYPES_TL PTT

7395: l_rec.CREATION_DATE
7396: from dual
7397: where not exists (
7398: select '1'
7399: from PAY_PAYMENT_TYPES_TL PTT
7400: where PTT.PAYMENT_TYPE_ID = l_rec.PAYMENT_TYPE_ID
7401: and PTT.language = l_rec.trans_lang);
7402:
7403: l_counter := l_counter + 1;