DBA Data[Home] [Help]

APPS.XLA_ANALYTICAL_CRITERIA_PKG dependencies on XLA_AE_LINE_ACS

Line 1213: FROM xla_ae_line_acs xald

1209: ,cp_ae_line_num INTEGER
1210: )
1211: IS
1212: SELECT 1
1213: FROM xla_ae_line_acs xald
1214: WHERE xald.ae_header_id = cp_ae_header_id
1215: AND xald.ae_line_num = cp_ae_line_num
1216: FOR UPDATE NOWAIT;
1217:

Line 1911: ,xla_ae_line_acs xald

1907: )
1908: IS
1909: SELECT 1
1910: FROM xla_ae_lines xal
1911: ,xla_ae_line_acs xald
1912: WHERE xal.ae_header_id = cp_ae_header_id
1913: AND xal.application_id = cp_application_id
1914: AND xald.ae_header_id = xal.ae_header_id
1915: AND xald.ae_line_num = xal.ae_line_num ---BugNo 10408339 Added for performance issue.

Line 1925: FROM xla_ae_line_acs xald

1921: ,cp_ae_line_num INTEGER
1922: )
1923: IS
1924: SELECT 1
1925: FROM xla_ae_line_acs xald
1926: WHERE xald.ae_header_id = cp_ae_header_id
1927: AND xald.ae_line_num = cp_ae_line_num
1928: FOR UPDATE NOWAIT;
1929:

Line 2163: FROM xla_ae_line_acs xald

2159: AND xal.ae_line_num = p_ae_line_num
2160: AND 0 =
2161: (
2162: SELECT count(xald.ae_line_num)
2163: FROM xla_ae_line_acs xald
2164: ,xla_analytical_hdrs_b xahb
2165: WHERE xald.ae_header_id = p_ae_header_id
2166: AND xald.ae_line_num = p_ae_line_num
2167: AND xahb.amb_context_code = xald.amb_context_code