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 3027: FROM xla_evt_class_acct_attrs e

3023: SELECT accounting_attribute_code
3024: FROM xla_acct_attributes_b a
3025: WHERE a.assignment_required_code = 'Y'
3026: AND NOT EXISTS (SELECT 'x'
3027: FROM xla_evt_class_acct_attrs e
3028: WHERE e.application_id = p_application_id
3029: AND e.event_class_code = p_event_class_code
3030: AND e.accounting_attribute_code = a.accounting_attribute_code
3031: AND e.default_flag = 'Y');

Line 3043: FROM xla_evt_class_acct_attrs e

3039: SELECT distinct assignment_group_code
3040: FROM xla_acct_attributes_b a
3041: WHERE assignment_group_code IS NOT NULL
3042: AND EXISTS (SELECT 'x'
3043: FROM xla_evt_class_acct_attrs e
3044: WHERE e.application_id = p_application_id
3045: AND e.event_class_code = p_event_class_code
3046: AND e.accounting_attribute_code = a.accounting_attribute_code
3047: AND e.default_flag = 'Y');

Line 3060: FROM xla_evt_class_acct_attrs e

3056: FROM xla_acct_attributes_b a
3057: WHERE a.assignment_required_code = 'G'
3058: AND a.assignment_group_code = l_mapping_groups.assignment_group_code
3059: AND NOT EXISTS (SELECT 'x'
3060: FROM xla_evt_class_acct_attrs e
3061: WHERE e.application_id = p_application_id
3062: AND e.event_class_code = p_event_class_code
3063: AND e.accounting_attribute_code = a.accounting_attribute_code
3064: AND e.default_flag = 'Y');

Line 3083: FROM xla_evt_class_acct_attrs e

3079: -- Check if event class has budget version id accounting source mapped
3080: CURSOR c_budget
3081: IS
3082: SELECT 'x'
3083: FROM xla_evt_class_acct_attrs e
3084: WHERE e.application_id = p_application_id
3085: AND e.event_class_code = p_event_class_code
3086: AND e.accounting_attribute_code = 'BUDGET_VERSION_ID'
3087: AND e.default_flag = 'Y';

Line 3094: FROM xla_evt_class_acct_attrs e

3090: /* 4458381
3091: CURSOR c_enc
3092: IS
3093: SELECT 'x'
3094: FROM xla_evt_class_acct_attrs e
3095: WHERE e.application_id = p_application_id
3096: AND e.event_class_code = p_event_class_code
3097: AND e.accounting_attribute_code = 'ENCUMBRANCE_TYPE_ID'
3098: AND e.default_flag = 'Y';

Line 3106: FROM xla_evt_class_acct_attrs_fvl a

3102: CURSOR c_rev_dist_2
3103: IS
3104: SELECT a.accounting_attribute_code, a.assignment_group_code,
3105: a.source_type_code, a.source_code
3106: FROM xla_evt_class_acct_attrs_fvl a
3107: WHERE a.application_id = p_application_id
3108: AND a.event_class_code = p_event_class_code
3109: AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID2'
3110: AND default_flag = 'Y';

Line 3118: FROM xla_evt_class_acct_attrs a

3114: -- Check if distribution id 2 is mapped for the event class
3115: CURSOR c_dist_2
3116: IS
3117: SELECT 'x'
3118: FROM xla_evt_class_acct_attrs a
3119: WHERE a.application_id = p_application_id
3120: AND a.event_class_code = p_event_class_code
3121: AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_2'
3122: AND default_flag = 'Y';

Line 3128: FROM xla_evt_class_acct_attrs_fvl a

3124: -- Check if reversed distribution id 3 is mapped for the event class
3125: CURSOR c_rev_dist_3
3126: IS
3127: SELECT a.accounting_attribute_code, a.assignment_group_code
3128: FROM xla_evt_class_acct_attrs_fvl a
3129: WHERE a.application_id = p_application_id
3130: AND a.event_class_code = p_event_class_code
3131: AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID3'
3132: AND default_flag = 'Y';

Line 3140: FROM xla_evt_class_acct_attrs a

3136: -- Check if distribution id 3 is mapped for the event class
3137: CURSOR c_dist_3
3138: IS
3139: SELECT 'x'
3140: FROM xla_evt_class_acct_attrs a
3141: WHERE a.application_id = p_application_id
3142: AND a.event_class_code = p_event_class_code
3143: AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_3'
3144: AND a.default_flag = 'Y';

Line 3150: FROM xla_evt_class_acct_attrs_fvl a

3146: -- Check if reversed distribution id 4 is mapped for the event class
3147: CURSOR c_rev_dist_4
3148: IS
3149: SELECT a.accounting_attribute_code, a.assignment_group_code
3150: FROM xla_evt_class_acct_attrs_fvl a
3151: WHERE a.application_id = p_application_id
3152: AND a.event_class_code = p_event_class_code
3153: AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID4'
3154: AND default_flag = 'Y';

Line 3162: FROM xla_evt_class_acct_attrs a

3158: -- Check if distribution id 4 is mapped for the event class
3159: CURSOR c_dist_4
3160: IS
3161: SELECT 'x'
3162: FROM xla_evt_class_acct_attrs a
3163: WHERE a.application_id = p_application_id
3164: AND a.event_class_code = p_event_class_code
3165: AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_4'
3166: AND default_flag = 'Y';

Line 3172: FROM xla_evt_class_acct_attrs_fvl a

3168: -- Check if reversed distribution id 5 is mapped for the event class
3169: CURSOR c_rev_dist_5
3170: IS
3171: SELECT a.accounting_attribute_code, a.assignment_group_code
3172: FROM xla_evt_class_acct_attrs_fvl a
3173: WHERE a.application_id = p_application_id
3174: AND a.event_class_code = p_event_class_code
3175: AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID5'
3176: AND a.default_flag = 'Y';

Line 3184: FROM xla_evt_class_acct_attrs a

3180: -- Check if distribution id 5 is mapped for the event class
3181: CURSOR c_dist_5
3182: IS
3183: SELECT 'x'
3184: FROM xla_evt_class_acct_attrs a
3185: WHERE a.application_id = p_application_id
3186: AND a.event_class_code = p_event_class_code
3187: AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_5'
3188: AND a.default_flag = 'Y';

Line 3197: FROM xla_evt_class_acct_attrs s

3193: CURSOR c_sources
3194: IS
3195: SELECT s.accounting_attribute_code,
3196: s.source_type_code, s.source_code
3197: FROM xla_evt_class_acct_attrs s
3198: WHERE s.application_id = p_application_id
3199: AND s.event_class_code = p_event_class_code
3200: AND s.source_application_id = p_application_id
3201: AND s.source_type_code = 'S'

Line 3220: FROM xla_evt_class_acct_attrs s

3216: CURSOR c_der_sources
3217: IS
3218: SELECT s.accounting_attribute_code, s.source_application_id,
3219: s.source_type_code, s.source_code
3220: FROM xla_evt_class_acct_attrs s
3221: WHERE s.application_id = p_application_id
3222: AND s.event_class_code = p_event_class_code
3223: AND s.source_application_id = p_application_id
3224: AND s.source_type_code = 'D';