DBA Data[Home] [Help]

APPS.PAY_ELEMENT_LINKS_PKG dependencies on PAY_ELEMENT_SET_MEMBERS

Line 1318: -- NB Because pay_element_set_members is a complex view it cannot

1314:
1315: cursor csr_distribution_set is
1316: --
1317: -- Returns a row if the element is in a distribution set
1318: -- NB Because pay_element_set_members is a complex view it cannot
1319: -- restrict on business group id and so I must use this as part of the
1320: -- join to it.
1321: --
1322: select 1

Line 1323: from pay_element_set_members MEMBER,

1319: -- restrict on business group id and so I must use this as part of the
1320: -- join to it.
1321: --
1322: select 1
1323: from pay_element_set_members MEMBER,
1324: pay_element_sets ELEMENT_SET
1325: where element_set.element_set_id = member.element_set_id
1326: and member.element_type_id = p_element_type_id
1327: and element_set.element_set_type = 'D'