DBA Data[Home] [Help]

APPS.XLA_AMB_AAD_PKG dependencies on XLA_ACCT_ATTRIBUTES_B

Line 197: FROM xla_acct_attributes_b a

193:
194: CURSOR c_reqd_acct_attr
195: IS
196: SELECT a.accounting_attribute_code
197: FROM xla_acct_attributes_b a
198: WHERE a.assignment_required_code = 'Y'
199: AND NOT EXISTS (SELECT 'x'
200: FROM xla_evt_class_acct_attrs e
201: WHERE e.application_id = p_application_id

Line 213: FROM xla_acct_attributes_b a

209: -- mapped for the event class
210: CURSOR c_mapping_group
211: IS
212: SELECT distinct a.assignment_group_code
213: FROM xla_acct_attributes_b a
214: WHERE assignment_group_code is NOT NULL
215: AND EXISTS (SELECT 'x'
216: FROM xla_evt_class_acct_attrs e
217: WHERE e.application_id = p_application_id

Line 229: FROM xla_acct_attributes_b s

225: -- which have not been mapped to the event class
226: CURSOR c_accting_sources (p_assignment_group_code VARCHAR2)
227: IS
228: SELECT accounting_attribute_code
229: FROM xla_acct_attributes_b s
230: WHERE assignment_required_code = 'G'
231: AND assignment_group_code = p_assignment_group_code
232: AND not exists (SELECT 'x'
233: FROM xla_evt_class_acct_attrs e