eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_CN_API dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1293: l_trans_name pay_element_classifications_tl.classification_name%TYPE;

1289:
1290: FUNCTION get_class_tl_name(p_classification_name IN VARCHAR2)
1291: RETURN VARCHAR2
1292: IS
1293: l_trans_name pay_element_classifications_tl.classification_name%TYPE;
1294:
1295: CURSOR csr_translated_value
1296: IS
1297: SELECT pectl.classification_name

Line 1298: FROM pay_element_classifications_tl pectl,

1294:
1295: CURSOR csr_translated_value
1296: IS
1297: SELECT pectl.classification_name
1298: FROM pay_element_classifications_tl pectl,
1299: pay_element_classifications pec
1300: WHERE pec.classification_id = pectl.classification_id
1301: AND pectl.language =USERENV('LANG')
1302: AND pec.classification_name = DECODE(p_classification_name,'Voluntary Dedn','Voluntary Deductions',p_classification_name)

Line 1299: pay_element_classifications pec

1295: CURSOR csr_translated_value
1296: IS
1297: SELECT pectl.classification_name
1298: FROM pay_element_classifications_tl pectl,
1299: pay_element_classifications pec
1300: WHERE pec.classification_id = pectl.classification_id
1301: AND pectl.language =USERENV('LANG')
1302: AND pec.classification_name = DECODE(p_classification_name,'Voluntary Dedn','Voluntary Deductions',p_classification_name)
1303: AND pec.legislation_code='CN';