eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_ELEMENT_LINKS_PKG dependencies on PAY_ELEMENT_SET_MEMBERS

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

1303:
1304: cursor csr_distribution_set is
1305: --
1306: -- Returns a row if the element is in a distribution set
1307: -- NB Because pay_element_set_members is a complex view it cannot
1308: -- restrict on business group id and so I must use this as part of the
1309: -- join to it.
1310: --
1311: select 1

Line 1312: from pay_element_set_members MEMBER,

1308: -- restrict on business group id and so I must use this as part of the
1309: -- join to it.
1310: --
1311: select 1
1312: from pay_element_set_members MEMBER,
1313: pay_element_sets ELEMENT_SET
1314: where element_set.element_set_id = member.element_set_id
1315: and member.element_type_id = p_element_type_id
1316: and element_set.element_set_type = 'D'