[Home] [Help]
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'
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