DBA Data[Home] [Help]

APPS.PAY_PEL_BUS dependencies on PAY_ELEMENT_TYPE_RULES

Line 1370: from pay_element_type_rules rule, pay_element_types_f type,

1366: exists (
1367: /* check the classifications of elements in the set that are specified
1368: directly by name */
1369: select 1
1370: from pay_element_type_rules rule, pay_element_types_f type,
1371: pay_element_classifications class
1372: where element_set.element_set_id = rule.element_set_id
1373: and class.classification_id = type.classification_id
1374: and type.element_type_id = rule.element_type_id

Line 1393: from pay_element_type_rules rule2, pay_element_types_f type2

1389: exists (
1390: /* check that there are elements directly included in
1391: the set or (see second half of union statement) */
1392: select 1
1393: from pay_element_type_rules rule2, pay_element_types_f type2
1394: where element_set.element_set_id=rule2.element_set_id
1395: and rule2.element_type_id=type2.element_type_id
1396: and rule2.include_or_exclude = 'I'
1397: and (type2.business_group_id = p_business_group_id