APPS.HR_LEGISLATION dependencies on PAY_ELEMENT_CLASSIFICATIONS_TL

Line 6870: -- PAY_ELEMENT_CLASSIFICATIONS_TL

6866: IS
6867: -- Install all startup data for multilingual tables.
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

Line 6999: -- Seeds the PAY_ELEMENT_CLASSIFICATIONS_TL table.

6995:
6996: PROCEDURE install_pect
6997: ----------------------
6998: IS
6999: -- Seeds the PAY_ELEMENT_CLASSIFICATIONS_TL table.
7000:
7001: CURSOR c_input_values IS
7002: select
7003: EC.CLASSIFICATION_ID,

Line 7022: from PAY_ELEMENT_CLASSIFICATIONS_TL ECT

7018: and NVL(TO_CHAR(EC.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7019: and
7020: ( not exists (
7021: select '1'
7022: from PAY_ELEMENT_CLASSIFICATIONS_TL ECT
7023: where ECT.CLASSIFICATION_ID = EC.CLASSIFICATION_ID
7024: and ECT.language = l.language_code)
7025: or exists (select '1' from PAY_ELEMENT_CLASSIFICATIONS_TL ect2
7026: where ect2.CLASSIFICATION_ID = ec.CLASSIFICATION_ID

Line 7025: or exists (select '1' from PAY_ELEMENT_CLASSIFICATIONS_TL ect2

7021: select '1'
7022: from PAY_ELEMENT_CLASSIFICATIONS_TL ECT
7023: where ECT.CLASSIFICATION_ID = EC.CLASSIFICATION_ID
7024: and ECT.language = l.language_code)
7025: or exists (select '1' from PAY_ELEMENT_CLASSIFICATIONS_TL ect2
7026: where ect2.CLASSIFICATION_ID = ec.CLASSIFICATION_ID
7027: and ect2.language = b.language_code
7028: and nvl( ect2.description,'ec.description' ||'1') <> nvl(ec.description,ect2.description || '-1'))
7029: );

Line 7038: delete PAY_ELEMENT_CLASSIFICATIONS_TL

7034:
7035:
7036: FOR l_rec IN c_input_values LOOP
7037:
7038: delete PAY_ELEMENT_CLASSIFICATIONS_TL
7039: where rowid in (select ectl.rowid
7040: from PAY_ELEMENT_CLASSIFICATIONS ec,
7041: PAY_ELEMENT_CLASSIFICATIONS_TL ectl
7042: where ec.CLASSIFICATION_ID = ectl.CLASSIFICATION_ID

Line 7041: PAY_ELEMENT_CLASSIFICATIONS_TL ectl

7037:
7038: delete PAY_ELEMENT_CLASSIFICATIONS_TL
7039: where rowid in (select ectl.rowid
7040: from PAY_ELEMENT_CLASSIFICATIONS ec,
7041: PAY_ELEMENT_CLASSIFICATIONS_TL ectl
7042: where ec.CLASSIFICATION_ID = ectl.CLASSIFICATION_ID
7043: and nvl(ec.DESCRIPTION, 'XXX') <>
7044: nvl(ectl.DESCRIPTION, 'XXX')
7045: and NVL(TO_CHAR(ec.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 7051: insert into PAY_ELEMENT_CLASSIFICATIONS_TL

7047: and ectl.language = l_rec.trans_lang);
7048:
7049: -- Insert all selected rows into the TL table.
7050: -- If the row exist in the TL table then it will be ignored.
7051: insert into PAY_ELEMENT_CLASSIFICATIONS_TL
7052: (
7053: CLASSIFICATION_ID,
7054: CLASSIFICATION_NAME,
7055: DESCRIPTION,

Line 7078: from PAY_ELEMENT_CLASSIFICATIONS_TL ECT

7074: l_rec.CREATION_DATE
7075: from dual
7076: where not exists (
7077: select '1'
7078: from PAY_ELEMENT_CLASSIFICATIONS_TL ECT
7079: where ECT.CLASSIFICATION_ID = l_rec.CLASSIFICATION_ID
7080: and ECT.language = l_rec.trans_lang);
7081:
7082: l_counter := l_counter + 1;