DBA Data[Home] [Help]

APPS.HR_ELEMENT_LINKS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 341: pay_element_classifications ec,

337: from sys.dual
338: where exists
339: (select 1
340: from pay_element_set_members esm,
341: pay_element_classifications ec,
342: pay_element_classifications ec2
343: where ec.classification_id = p_classification_id
344: and esm.element_set_id = p_element_set_id
345: and ec2.classification_id = esm.classification_id

Line 342: pay_element_classifications ec2

338: where exists
339: (select 1
340: from pay_element_set_members esm,
341: pay_element_classifications ec,
342: pay_element_classifications ec2
343: where ec.classification_id = p_classification_id
344: and esm.element_set_id = p_element_set_id
345: and ec2.classification_id = esm.classification_id
346: and ec2.costing_debit_or_credit <> ec.costing_debit_or_credit);