APPS.XLA_JE_VALIDATION_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 7087: AND EXISTS (select 1 from xla_distribution_links xdl

7083: FROM xla_validation_lines_gt l
7084: ,fun_bal_headers_gt h
7085: WHERE l.balancing_line_type = C_LINE_TYPE_PROCESS
7086: AND l.ae_header_id = h.group_id
7087: AND EXISTS (select 1 from xla_distribution_links xdl
7088: where xdl.ae_header_id= l.ae_header_id
7089: and xdl.ae_line_num= l.ae_line_num
7090: and (xdl.temp_line_num IS NULL or xdl.temp_line_num >0));
7091:

Line 7127: AND EXISTS (select 1 from xla_distribution_links xdl

7123: FROM xla_validation_lines_gt l
7124: ,fun_bal_headers_gt h
7125: WHERE l.balancing_line_type = C_LINE_TYPE_PROCESS
7126: AND l.ae_header_id = h.group_id
7127: AND EXISTS (select 1 from xla_distribution_links xdl
7128: where xdl.ae_header_id= l.ae_header_id
7129: and xdl.ae_line_num= l.ae_line_num
7130: and xdl.temp_line_num <0)
7131: ;

Line 7253: AND EXISTS (select 1 from xla_distribution_links xdl

7249: WHERE l.ae_line_num = l.max_ae_line_num
7250: AND l.ae_header_id = res.group_id
7251: AND ccid.code_combination_id= res.ccid
7252: AND res.entered_currency_code = fcu.currency_code
7253: AND EXISTS (select 1 from xla_distribution_links xdl
7254: where xdl.ae_header_id= l.ae_header_id
7255: and xdl.ae_line_num= l.ae_line_num
7256: and (xdl.temp_line_num IS NULL or xdl.temp_line_num >0));
7257:

Line 7352: AND EXISTS (select 1 from xla_distribution_links xdl

7348: WHERE l.ae_line_num = l.max_ae_line_num
7349: AND l.ae_header_id = res.group_id
7350: AND ccid.code_combination_id= res.ccid
7351: AND res.entered_currency_code = fcu.currency_code
7352: AND EXISTS (select 1 from xla_distribution_links xdl
7353: where xdl.ae_header_id= l.ae_header_id
7354: and xdl.ae_line_num= l.ae_line_num
7355: and xdl.temp_line_num <0);
7356: