APPS.XLA_LINE_DEFINITIONS_PVT dependencies on XLA_LOOKUPS

Line 2816: FROM xla_lookups xlk

2812: AND xld.line_definition_code = p_line_definition_code
2813: AND xld.active_flag = 'Y'
2814: AND NOT EXISTS
2815: (SELECT 'y'
2816: FROM xla_lookups xlk
2817: WHERE xlk.lookup_type = 'XLA_ACCOUNTING_CLASS'
2818: AND xlk.lookup_code = xal.accounting_class_code);
2819:
2820: l_return BOOLEAN;

Line 2929: FROM xla_lookups xlk

2925: AND xld.line_definition_code = p_line_definition_code
2926: AND xld.active_flag = 'Y'
2927: AND NOT EXISTS
2928: (SELECT 'y'
2929: FROM xla_lookups xlk
2930: WHERE xlk.lookup_type = 'XLA_ACCOUNTING_CLASS'
2931: AND xlk.lookup_code = xal.rounding_class_code);
2932:
2933: l_return BOOLEAN;

Line 3043: FROM xla_lookups xlk

3039: AND xld.line_definition_code = p_line_definition_code
3040: AND xld.active_flag = 'Y'
3041: AND NOT EXISTS
3042: (SELECT 'y'
3043: FROM xla_lookups xlk
3044: WHERE xlk.lookup_type = 'XLA_BUSINESS_FLOW_CLASS'
3045: AND xlk.lookup_code = xal.business_class_code);
3046:
3047: l_return BOOLEAN;

Line 3282: FROM xla_lookups lkp

3278: AND xal.accounting_line_code = xld.accounting_line_code
3279: AND xal.business_class_code IS NOT NULL
3280: AND NOT EXISTS
3281: (SELECT 'y'
3282: FROM xla_lookups lkp
3283: WHERE lkp.lookup_code = xal.business_class_code
3284: AND lkp.lookup_type = 'XLA_BUSINESS_FLOW_CLASS'
3285: AND lkp.enabled_flag = 'Y'
3286: AND lkp.end_date_active IS NULL);

Line 6257: FROM xla_lookups xlk

6253: AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
6254: AND xld1.accounting_line_code = mpa.mpa_accounting_line_code)
6255: AND NOT EXISTS
6256: (SELECT 'y'
6257: FROM xla_lookups xlk
6258: WHERE xlk.lookup_type = 'XLA_ACCOUNTING_CLASS'
6259: AND xlk.lookup_code = xal.accounting_class_code);
6260:
6261: l_return BOOLEAN;

Line 12418: ,xla_lookups xlk

12414: SELECT xpr.name product_rule_name
12415: ,xlk.meaning product_rule_owner
12416: FROM xla_aad_line_defn_assgns xal
12417: ,xla_product_rules_tl xpr
12418: ,xla_lookups xlk
12419: WHERE xpr.application_id = xal.application_id
12420: AND xpr.amb_context_code = xal.amb_context_code
12421: AND xpr.product_rule_type_code = xal.product_rule_type_code
12422: AND xpr.product_rule_code = xal.product_rule_code

Line 13609: ,xla_lookups xlk

13605: IS
13606: CURSOR c_line_defn IS
13607: SELECT xld.name, xlk.meaning owner
13608: FROM xla_line_definitions_tl xld
13609: ,xla_lookups xlk
13610: WHERE xld.application_id = p_application_id
13611: AND xld.amb_context_code = p_amb_context_code
13612: AND xld.event_class_code = p_event_class_code
13613: AND xld.event_type_code = p_event_type_code