DBA Data[Home] [Help]

APPS.HR_CN_API dependencies on PAY_ELEMENT_CLASSIFICATIONS_TL

Line 1301: l_trans_name pay_element_classifications_tl.classification_name%TYPE;

1297:
1298: FUNCTION get_class_tl_name(p_classification_name IN VARCHAR2)
1299: RETURN VARCHAR2
1300: IS
1301: l_trans_name pay_element_classifications_tl.classification_name%TYPE;
1302:
1303: CURSOR csr_translated_value
1304: IS
1305: SELECT pectl.classification_name

Line 1306: FROM pay_element_classifications_tl pectl,

1302:
1303: CURSOR csr_translated_value
1304: IS
1305: SELECT pectl.classification_name
1306: FROM pay_element_classifications_tl pectl,
1307: pay_element_classifications pec
1308: WHERE pec.classification_id = pectl.classification_id
1309: AND pectl.language =USERENV('LANG')
1310: AND pec.classification_name = DECODE(p_classification_name,'Voluntary Dedn','Voluntary Deductions',p_classification_name)