eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_EXTRACT_INTEGRITY_PKG dependencies on XLA_EVT_CLASS_ACCT_ATTRS

Line 2272: FROM xla_evt_class_acct_attrs e

2268: SELECT accounting_attribute_code
2269: FROM xla_acct_attributes_b a
2270: WHERE a.assignment_required_code = 'Y'
2271: AND NOT EXISTS (SELECT 'x'
2272: FROM xla_evt_class_acct_attrs e
2273: WHERE e.application_id = p_application_id
2274: AND e.event_class_code = p_event_class_code
2275: AND e.accounting_attribute_code = a.accounting_attribute_code
2276: AND e.default_flag = 'Y');

Line 2288: FROM xla_evt_class_acct_attrs e

2284: SELECT distinct assignment_group_code
2285: FROM xla_acct_attributes_b a
2286: WHERE assignment_group_code IS NOT NULL
2287: AND EXISTS (SELECT 'x'
2288: FROM xla_evt_class_acct_attrs e
2289: WHERE e.application_id = p_application_id
2290: AND e.event_class_code = p_event_class_code
2291: AND e.accounting_attribute_code = a.accounting_attribute_code
2292: AND e.default_flag = 'Y');

Line 2305: FROM xla_evt_class_acct_attrs e

2301: FROM xla_acct_attributes_b a
2302: WHERE a.assignment_required_code = 'G'
2303: AND a.assignment_group_code = l_mapping_groups.assignment_group_code
2304: AND NOT EXISTS (SELECT 'x'
2305: FROM xla_evt_class_acct_attrs e
2306: WHERE e.application_id = p_application_id
2307: AND e.event_class_code = p_event_class_code
2308: AND e.accounting_attribute_code = a.accounting_attribute_code
2309: AND e.default_flag = 'Y');

Line 2328: FROM xla_evt_class_acct_attrs e

2324: -- Check if event class has budget version id accounting source mapped
2325: CURSOR c_budget
2326: IS
2327: SELECT 'x'
2328: FROM xla_evt_class_acct_attrs e
2329: WHERE e.application_id = p_application_id
2330: AND e.event_class_code = p_event_class_code
2331: AND e.accounting_attribute_code = 'BUDGET_VERSION_ID'
2332: AND e.default_flag = 'Y';

Line 2339: FROM xla_evt_class_acct_attrs e

2335: /* 4458381
2336: CURSOR c_enc
2337: IS
2338: SELECT 'x'
2339: FROM xla_evt_class_acct_attrs e
2340: WHERE e.application_id = p_application_id
2341: AND e.event_class_code = p_event_class_code
2342: AND e.accounting_attribute_code = 'ENCUMBRANCE_TYPE_ID'
2343: AND e.default_flag = 'Y';

Line 2351: FROM xla_evt_class_acct_attrs_fvl a

2347: CURSOR c_rev_dist_2
2348: IS
2349: SELECT a.accounting_attribute_code, a.assignment_group_code,
2350: a.source_type_code, a.source_code
2351: FROM xla_evt_class_acct_attrs_fvl a
2352: WHERE a.application_id = p_application_id
2353: AND a.event_class_code = p_event_class_code
2354: AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID2'
2355: AND default_flag = 'Y';

Line 2363: FROM xla_evt_class_acct_attrs a

2359: -- Check if distribution id 2 is mapped for the event class
2360: CURSOR c_dist_2
2361: IS
2362: SELECT 'x'
2363: FROM xla_evt_class_acct_attrs a
2364: WHERE a.application_id = p_application_id
2365: AND a.event_class_code = p_event_class_code
2366: AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_2'
2367: AND default_flag = 'Y';

Line 2373: FROM xla_evt_class_acct_attrs_fvl a

2369: -- Check if reversed distribution id 3 is mapped for the event class
2370: CURSOR c_rev_dist_3
2371: IS
2372: SELECT a.accounting_attribute_code, a.assignment_group_code
2373: FROM xla_evt_class_acct_attrs_fvl a
2374: WHERE a.application_id = p_application_id
2375: AND a.event_class_code = p_event_class_code
2376: AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID3'
2377: AND default_flag = 'Y';

Line 2385: FROM xla_evt_class_acct_attrs a

2381: -- Check if distribution id 3 is mapped for the event class
2382: CURSOR c_dist_3
2383: IS
2384: SELECT 'x'
2385: FROM xla_evt_class_acct_attrs a
2386: WHERE a.application_id = p_application_id
2387: AND a.event_class_code = p_event_class_code
2388: AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_3'
2389: AND a.default_flag = 'Y';

Line 2395: FROM xla_evt_class_acct_attrs_fvl a

2391: -- Check if reversed distribution id 4 is mapped for the event class
2392: CURSOR c_rev_dist_4
2393: IS
2394: SELECT a.accounting_attribute_code, a.assignment_group_code
2395: FROM xla_evt_class_acct_attrs_fvl a
2396: WHERE a.application_id = p_application_id
2397: AND a.event_class_code = p_event_class_code
2398: AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID4'
2399: AND default_flag = 'Y';

Line 2407: FROM xla_evt_class_acct_attrs a

2403: -- Check if distribution id 4 is mapped for the event class
2404: CURSOR c_dist_4
2405: IS
2406: SELECT 'x'
2407: FROM xla_evt_class_acct_attrs a
2408: WHERE a.application_id = p_application_id
2409: AND a.event_class_code = p_event_class_code
2410: AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_4'
2411: AND default_flag = 'Y';

Line 2417: FROM xla_evt_class_acct_attrs_fvl a

2413: -- Check if reversed distribution id 5 is mapped for the event class
2414: CURSOR c_rev_dist_5
2415: IS
2416: SELECT a.accounting_attribute_code, a.assignment_group_code
2417: FROM xla_evt_class_acct_attrs_fvl a
2418: WHERE a.application_id = p_application_id
2419: AND a.event_class_code = p_event_class_code
2420: AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID5'
2421: AND a.default_flag = 'Y';

Line 2429: FROM xla_evt_class_acct_attrs a

2425: -- Check if distribution id 5 is mapped for the event class
2426: CURSOR c_dist_5
2427: IS
2428: SELECT 'x'
2429: FROM xla_evt_class_acct_attrs a
2430: WHERE a.application_id = p_application_id
2431: AND a.event_class_code = p_event_class_code
2432: AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_5'
2433: AND a.default_flag = 'Y';

Line 2442: FROM xla_evt_class_acct_attrs s

2438: CURSOR c_sources
2439: IS
2440: SELECT s.accounting_attribute_code,
2441: s.source_type_code, s.source_code
2442: FROM xla_evt_class_acct_attrs s
2443: WHERE s.application_id = p_application_id
2444: AND s.event_class_code = p_event_class_code
2445: AND s.source_application_id = p_application_id
2446: AND s.source_type_code = 'S'

Line 2465: FROM xla_evt_class_acct_attrs s

2461: CURSOR c_der_sources
2462: IS
2463: SELECT s.accounting_attribute_code, s.source_application_id,
2464: s.source_type_code, s.source_code
2465: FROM xla_evt_class_acct_attrs s
2466: WHERE s.application_id = p_application_id
2467: AND s.event_class_code = p_event_class_code
2468: AND s.source_application_id = p_application_id
2469: AND s.source_type_code = 'D';