APPS.PAY_ELEMENT_SETS_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 103: from pay_element_classifications ecl

99: ) is
100: --
101: cursor csr_debit_or_credit_ele_rule is
102: select ecl.costing_debit_or_credit
103: from pay_element_classifications ecl
104: where ecl.classification_id = p_classification_id
105: and exists
106: (select null
107: from pay_element_type_rules etr,

Line 109: pay_element_classifications ecl2

105: and exists
106: (select null
107: from pay_element_type_rules etr,
108: pay_element_types_f et,
109: pay_element_classifications ecl2
110: where etr.element_set_id = p_element_set_id
111: and et.element_type_id = etr.element_type_id
112: and ecl2.classification_id = et.classification_id
113: and ecl2.costing_debit_or_credit <>

Line 118: from pay_element_classifications ecl

114: ecl.costing_debit_or_credit);
115: --
116: cursor csr_debit_or_credit_class_rule is
117: select ecl.costing_debit_or_credit
118: from pay_element_classifications ecl
119: where ecl.classification_id = p_classification_id
120: and exists
121: (select null
122: from pay_ele_classification_rules ecr,

Line 123: pay_element_classifications ecl2

119: where ecl.classification_id = p_classification_id
120: and exists
121: (select null
122: from pay_ele_classification_rules ecr,
123: pay_element_classifications ecl2
124: where ecr.element_set_id = p_element_set_id
125: and ecl2.classification_id = ecr.classification_id
126: and ecl2.costing_debit_or_credit <>
127: ecl.costing_debit_or_credit);