DBA Data[Home] [Help]

APPS.PSP_PSPENASG_XMLP_PKG dependencies on PSP_ELEMENT_TYPE_ACCOUNTS

Line 149: Psp_element_type_accounts peta

145:
146: CURSOR c_element_acct IS
147: SELECT pet.element_name
148: FROM pay_element_types_f pet,
149: Psp_element_type_accounts peta
150: WHERE pet.element_type_id = peta.element_type_id
151: AND Peta.element_account_id = reference_id
152: AND ( trunc(sysdate) BETWEEN pet.effective_start_date AND
153: pet.effective_end_date