DBA Data[Home] [Help]

APPS.FII_FA_EXP_B_C dependencies on XLA_EVENTS

Line 1085: xla_events ev_rb,

1081: delete from fii_fa_exp_f
1082: where xla_event_id in
1083: (select ev_dep.event_id
1084: from fii_fa_new_exp_hdr_ids nid,
1085: xla_events ev_rb,
1086: xla_events ev_dep
1087: where nid.record_id between p_start_range and p_end_range
1088: and nid.event_type_code = 'ROLLBACK_DEPRECIATION'
1089: and ev_rb.event_id = nid.event_id

Line 1086: xla_events ev_dep

1082: where xla_event_id in
1083: (select ev_dep.event_id
1084: from fii_fa_new_exp_hdr_ids nid,
1085: xla_events ev_rb,
1086: xla_events ev_dep
1087: where nid.record_id between p_start_range and p_end_range
1088: and nid.event_type_code = 'ROLLBACK_DEPRECIATION'
1089: and ev_rb.event_id = nid.event_id
1090: and ev_rb.application_id = 140

Line 1942: xla_events ev_rb,

1938: and headers.ae_header_id not in
1939: (select /*+ hash_aj parallel(headers2, ev_rb, ev_dep) */
1940: headers2.ae_header_id
1941: from xla_ae_headers headers2,
1942: xla_events ev_rb,
1943: xla_events ev_dep
1944: where headers2.application_id = 140
1945: and headers2.event_type_code = 'DEPRECIATION'
1946: and ev_dep.event_id = headers2.event_id

Line 1943: xla_events ev_dep

1939: (select /*+ hash_aj parallel(headers2, ev_rb, ev_dep) */
1940: headers2.ae_header_id
1941: from xla_ae_headers headers2,
1942: xla_events ev_rb,
1943: xla_events ev_dep
1944: where headers2.application_id = 140
1945: and headers2.event_type_code = 'DEPRECIATION'
1946: and ev_dep.event_id = headers2.event_id
1947: and ev_dep.application_id = 140