DBA Data[Home] [Help]

APPS.PAY_IN_UTILS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 2380: ,pay_element_classifications pec

2376: ,'Non Monetary Perquisite',2
2377: ,-1
2378: )
2379: FROM pay_sub_classification_rules_f pscr
2380: ,pay_element_classifications pec
2381: WHERE pscr.classification_id = pec.classification_id
2382: AND pec.parent_classification_id =
2383: (SELECT classification_id FROM pay_element_classifications
2384: WHERE classification_name = 'Perquisites'

Line 2383: (SELECT classification_id FROM pay_element_classifications

2379: FROM pay_sub_classification_rules_f pscr
2380: ,pay_element_classifications pec
2381: WHERE pscr.classification_id = pec.classification_id
2382: AND pec.parent_classification_id =
2383: (SELECT classification_id FROM pay_element_classifications
2384: WHERE classification_name = 'Perquisites'
2385: AND legislation_code = 'IN'
2386: )
2387: AND element_type_id = p_element_type_id