DBA Data[Home] [Help]

APPS.PAY_IN_UTILS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 2365: ,pay_element_classifications pec

2361: ,'Non Monetary Perquisite',2
2362: ,-1
2363: )
2364: FROM pay_sub_classification_rules_f pscr
2365: ,pay_element_classifications pec
2366: WHERE pscr.classification_id = pec.classification_id
2367: AND pec.parent_classification_id =
2368: (SELECT classification_id FROM pay_element_classifications
2369: WHERE classification_name = 'Perquisites'

Line 2368: (SELECT classification_id FROM pay_element_classifications

2364: FROM pay_sub_classification_rules_f pscr
2365: ,pay_element_classifications pec
2366: WHERE pscr.classification_id = pec.classification_id
2367: AND pec.parent_classification_id =
2368: (SELECT classification_id FROM pay_element_classifications
2369: WHERE classification_name = 'Perquisites'
2370: AND legislation_code = 'IN'
2371: )
2372: AND element_type_id = p_element_type_id