DBA Data[Home] [Help]

APPS.PAY_PEL_BUS dependencies on PAY_ELE_CLASSIFICATION_RULES

Line 1381: from pay_ele_classification_rules class_rule,

1377: and type.effective_end_date
1378: union all
1379: /* check the element classifications specified in the set */
1380: select 1
1381: from pay_ele_classification_rules class_rule,
1382: pay_element_classifications class2
1383: where class_rule.element_set_id = element_set.element_set_id
1384: and class2.classification_id = class_rule.classification_id
1385: and class2.costing_debit_or_credit = p_costing_dc)

Line 1406: from pay_element_types_f type3, pay_ele_classification_rules class_rule2

1402: union all
1403: /* check that there are elements with the classification that is included
1404: in the set */
1405: select 1
1406: from pay_element_types_f type3, pay_ele_classification_rules class_rule2
1407: where class_rule2.element_set_id = element_set.element_set_id
1408: and class_rule2.classification_id = type3.classification_id
1409: and (type3.business_group_id = p_business_group_id
1410: or (type3.business_group_id is null