APPS.HR_LEGISLATION dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 734: ,pay_element_classifications pec

730: SELECT distinct ao.key_name
731: ,ao.product_name
732: ,ao.key_value
733: FROM hr_s_application_ownerships ao
734: ,pay_element_classifications pec
735: WHERE pec.legislation_code = 'ZZ'
736: AND ao.key_name = 'CLASSIFICATION_ID'
737: AND TO_NUMBER(ao.key_value) = pec.classification_id
738: AND NOT EXISTS (SELECT null

Line 2456: from pay_element_classifications

2452:
2453: BEGIN
2454: select distinct null
2455: into l_null_return
2456: from pay_element_classifications
2457: where classification_id = bal_classes.classification_id;
2458:
2459: EXCEPTION WHEN NO_DATA_FOUND THEN
2460: crt_exc('Parent element classification does not exist');

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 7013: from PAY_ELEMENT_CLASSIFICATIONS EC,

7009: EC.LAST_UPDATED_BY,
7010: EC.LAST_UPDATE_LOGIN,
7011: EC.CREATED_BY,
7012: EC.CREATION_DATE
7013: from PAY_ELEMENT_CLASSIFICATIONS EC,
7014: FND_LANGUAGES L,
7015: FND_LANGUAGES B
7016: where L.INSTALLED_FLAG in ('I', 'B')
7017: and B.INSTALLED_FLAG = 'B'

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 7040: from PAY_ELEMENT_CLASSIFICATIONS ec,

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
7043: and nvl(ec.DESCRIPTION, 'XXX') <>
7044: nvl(ectl.DESCRIPTION, 'XXX')

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;