APPS.HR_LEGISLATION dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 529: ,pay_element_classifications pec

525: SELECT distinct ao.key_name
526: ,ao.product_name
527: ,ao.key_value
528: FROM hr_s_application_ownerships ao
529: ,pay_element_classifications pec
530: WHERE pec.legislation_code = 'ZZ'
531: AND ao.key_name = 'CLASSIFICATION_ID'
532: AND TO_NUMBER(ao.key_value) = pec.classification_id
533: AND NOT EXISTS (SELECT null

Line 2229: from pay_element_classifications

2225:
2226: BEGIN
2227: select distinct null
2228: into l_null_return
2229: from pay_element_classifications
2230: where classification_id = bal_classes.classification_id;
2231:
2232: EXCEPTION WHEN NO_DATA_FOUND THEN
2233: crt_exc('Parent element classification does not exist');

Line 6620: -- PAY_ELEMENT_CLASSIFICATIONS_TL

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

Line 6749: -- Seeds the PAY_ELEMENT_CLASSIFICATIONS_TL table.

6745:
6746: PROCEDURE install_pect
6747: ----------------------
6748: IS
6749: -- Seeds the PAY_ELEMENT_CLASSIFICATIONS_TL table.
6750:
6751: CURSOR c_input_values IS
6752: select
6753: EC.CLASSIFICATION_ID,

Line 6763: from PAY_ELEMENT_CLASSIFICATIONS EC,

6759: EC.LAST_UPDATED_BY,
6760: EC.LAST_UPDATE_LOGIN,
6761: EC.CREATED_BY,
6762: EC.CREATION_DATE
6763: from PAY_ELEMENT_CLASSIFICATIONS EC,
6764: FND_LANGUAGES L,
6765: FND_LANGUAGES B
6766: where L.INSTALLED_FLAG in ('I', 'B')
6767: and B.INSTALLED_FLAG = 'B'

Line 6772: from PAY_ELEMENT_CLASSIFICATIONS_TL ECT

6768: and NVL(TO_CHAR(EC.BUSINESS_GROUP_ID),'Null Value')='Null Value'
6769: and
6770: ( not exists (
6771: select '1'
6772: from PAY_ELEMENT_CLASSIFICATIONS_TL ECT
6773: where ECT.CLASSIFICATION_ID = EC.CLASSIFICATION_ID
6774: and ECT.language = l.language_code)
6775: or exists (select '1' from PAY_ELEMENT_CLASSIFICATIONS_TL ect2
6776: where ect2.CLASSIFICATION_ID = ec.CLASSIFICATION_ID

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

6771: select '1'
6772: from PAY_ELEMENT_CLASSIFICATIONS_TL ECT
6773: where ECT.CLASSIFICATION_ID = EC.CLASSIFICATION_ID
6774: and ECT.language = l.language_code)
6775: or exists (select '1' from PAY_ELEMENT_CLASSIFICATIONS_TL ect2
6776: where ect2.CLASSIFICATION_ID = ec.CLASSIFICATION_ID
6777: and ect2.language = b.language_code
6778: and nvl( ect2.description,'ec.description' ||'1') <> nvl(ec.description,ect2.description || '-1'))
6779: );

Line 6788: delete PAY_ELEMENT_CLASSIFICATIONS_TL

6784:
6785:
6786: FOR l_rec IN c_input_values LOOP
6787:
6788: delete PAY_ELEMENT_CLASSIFICATIONS_TL
6789: where rowid in (select ectl.rowid
6790: from PAY_ELEMENT_CLASSIFICATIONS ec,
6791: PAY_ELEMENT_CLASSIFICATIONS_TL ectl
6792: where ec.CLASSIFICATION_ID = ectl.CLASSIFICATION_ID

Line 6790: from PAY_ELEMENT_CLASSIFICATIONS ec,

6786: FOR l_rec IN c_input_values LOOP
6787:
6788: delete PAY_ELEMENT_CLASSIFICATIONS_TL
6789: where rowid in (select ectl.rowid
6790: from PAY_ELEMENT_CLASSIFICATIONS ec,
6791: PAY_ELEMENT_CLASSIFICATIONS_TL ectl
6792: where ec.CLASSIFICATION_ID = ectl.CLASSIFICATION_ID
6793: and nvl(ec.DESCRIPTION, 'XXX') <>
6794: nvl(ectl.DESCRIPTION, 'XXX')

Line 6791: PAY_ELEMENT_CLASSIFICATIONS_TL ectl

6787:
6788: delete PAY_ELEMENT_CLASSIFICATIONS_TL
6789: where rowid in (select ectl.rowid
6790: from PAY_ELEMENT_CLASSIFICATIONS ec,
6791: PAY_ELEMENT_CLASSIFICATIONS_TL ectl
6792: where ec.CLASSIFICATION_ID = ectl.CLASSIFICATION_ID
6793: and nvl(ec.DESCRIPTION, 'XXX') <>
6794: nvl(ectl.DESCRIPTION, 'XXX')
6795: and NVL(TO_CHAR(ec.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 6801: insert into PAY_ELEMENT_CLASSIFICATIONS_TL

6797: and ectl.language = l_rec.trans_lang);
6798:
6799: -- Insert all selected rows into the TL table.
6800: -- If the row exist in the TL table then it will be ignored.
6801: insert into PAY_ELEMENT_CLASSIFICATIONS_TL
6802: (
6803: CLASSIFICATION_ID,
6804: CLASSIFICATION_NAME,
6805: DESCRIPTION,

Line 6828: from PAY_ELEMENT_CLASSIFICATIONS_TL ECT

6824: l_rec.CREATION_DATE
6825: from dual
6826: where not exists (
6827: select '1'
6828: from PAY_ELEMENT_CLASSIFICATIONS_TL ECT
6829: where ECT.CLASSIFICATION_ID = l_rec.CLASSIFICATION_ID
6830: and ECT.language = l_rec.trans_lang);
6831:
6832: l_counter := l_counter + 1;