APPS.XLA_LINE_TYPES_PKG dependencies on XLA_ACCT_ATTRIBUTES_B

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 1197: FROM xla_acct_attributes_b l

1193: ,g_created_by
1194: ,g_last_update_date
1195: ,g_last_updated_by
1196: ,g_last_update_login
1197: FROM xla_acct_attributes_b l
1198: WHERE l.assignment_level_code = 'JLT_ONLY'
1199: );
1200: ELSE
1201: INSERT into xla_jlt_acct_attrs(

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 1253: FROM xla_acct_attributes_b l

1249: ,g_created_by
1250: ,g_last_update_date
1251: ,g_last_updated_by
1252: ,g_last_update_login
1253: FROM xla_acct_attributes_b l
1254: WHERE l.assignment_level_code = 'JLT_ONLY');
1255: END IF;
1256:
1257: IF p_business_method_code = 'PRIOR_ENTRY' THEN

Line 1684: FROM xla_acct_attributes_b s

1680: -- Get all mapping groups that have accounting sources mapped for the line type
1681: CURSOR c_mapping_group
1682: IS
1683: SELECT distinct s.assignment_group_code
1684: FROM xla_acct_attributes_b s
1685: WHERE s.assignment_group_code IS NOT NULL
1686: AND EXISTS (SELECT 'x'
1687: FROM xla_jlt_acct_attrs a
1688: WHERE a.application_id = p_application_id

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