APPS.XLA_LINE_TYPES_PKG dependencies on XLA_EVT_CLASS_ACCT_ATTRS

Line 885: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l

881: CURSOR c_attr_source
882: IS
883: SELECT e.accounting_attribute_code, e.source_application_id,
884: e.source_type_code, e.source_code
885: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l
886: WHERE e.application_id = p_application_id
887: AND e.event_class_code = p_event_class_code
888: AND e.default_flag = 'Y'
889: AND e.accounting_attribute_code = l.accounting_attribute_code

Line 942: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l

938: ,g_created_by
939: ,g_last_update_date
940: ,g_last_updated_by
941: ,g_last_update_login
942: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l
943: WHERE e.application_id = p_application_id
944: AND e.event_class_code = p_event_class_code
945: AND e.accounting_attribute_code = l.accounting_attribute_code
946: AND l.assignment_level_code = 'EVT_CLASS_JLT'

Line 1101: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l

1097: CURSOR c_attr_source
1098: IS
1099: SELECT e.accounting_attribute_code, e.source_application_id,
1100: e.source_type_code, e.source_code
1101: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l
1102: WHERE e.application_id = p_application_id
1103: AND e.event_class_code = p_event_class_code
1104: AND e.default_flag = 'Y'
1105: AND e.accounting_attribute_code = l.accounting_attribute_code

Line 1112: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l

1108: CURSOR c_prior_entry_source
1109: IS
1110: SELECT e.accounting_attribute_code, e.source_application_id,
1111: e.source_type_code, e.source_code
1112: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l
1113: WHERE e.application_id = p_application_id
1114: AND e.event_class_code = p_event_class_code
1115: AND e.default_flag = 'Y'
1116: AND e.accounting_attribute_code = l.accounting_attribute_code

Line 1168: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l

1164: ,g_created_by
1165: ,g_last_update_date
1166: ,g_last_updated_by
1167: ,g_last_update_login
1168: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l
1169: WHERE e.application_id = p_application_id
1170: AND e.event_class_code = p_event_class_code
1171: AND e.accounting_attribute_code = l.accounting_attribute_code
1172: AND l.assignment_level_code = 'EVT_CLASS_JLT'

Line 1232: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l

1228: ,g_created_by
1229: ,g_last_update_date
1230: ,g_last_updated_by
1231: ,g_last_update_login
1232: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l
1233: WHERE e.application_id = p_application_id
1234: AND e.event_class_code = p_event_class_code
1235: AND e.accounting_attribute_code = l.accounting_attribute_code
1236: AND l.assignment_level_code = 'EVT_CLASS_JLT'

Line 1589: FROM xla_evt_class_acct_attrs e, xla_sources_tl s, xla_lookups l

1585: CURSOR c_dflt_source
1586: IS
1587: SELECT e.source_application_id, e.source_type_code, e.source_code,
1588: s.name, l.meaning source_type_dsp
1589: FROM xla_evt_class_acct_attrs e, xla_sources_tl s, xla_lookups l
1590: WHERE e.application_id = p_application_id
1591: AND e.event_class_code = p_event_class_code
1592: AND e.accounting_attribute_code = p_accounting_attribute_code
1593: AND e.default_flag = 'Y'

Line 1697: FROM xla_evt_class_acct_attrs_fvl e

1693: AND a.accounting_attribute_code = s.accounting_attribute_code
1694: AND a.source_code IS NOT NULL
1695: UNION
1696: SELECT 'x'
1697: FROM xla_evt_class_acct_attrs_fvl e
1698: WHERE e.application_id = p_application_id
1699: AND e.event_class_code = p_event_class_code
1700: AND e.accounting_attribute_code = s.accounting_attribute_code
1701: AND e.assignment_level_code = 'EVT_CLASS_ONLY'

Line 2018: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l

2014:
2015: CURSOR c_prior_entry
2016: IS
2017: SELECT e.accounting_attribute_code
2018: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l
2019: WHERE e.application_id = p_application_id
2020: AND e.event_class_code = p_event_class_code
2021: AND e.default_flag = 'Y'
2022: AND e.accounting_attribute_code = l.accounting_attribute_code

Line 2030: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l

2026: CURSOR c_non_prior_entry
2027: IS
2028: SELECT e.accounting_attribute_code, e.source_application_id,
2029: e.source_type_code, e.source_code
2030: FROM xla_evt_class_acct_attrs e, xla_acct_attributes_b l
2031: WHERE e.application_id = p_application_id
2032: AND e.event_class_code = p_event_class_code
2033: AND e.default_flag = 'Y'
2034: AND e.accounting_attribute_code = l.accounting_attribute_code