DBA Data[Home] [Help]

APPS.XLA_EVT_CLASS_ACCT_ATTRS_PKG dependencies on XLA_AAD_LINE_DEFN_ASSGNS

Line 122: FROM xla_aad_line_defn_assgns xal

118: FROM xla_prod_acct_headers xpa
119: WHERE xpa.application_id = p_application_id
120: AND xpa.event_class_code = p_event_class_code
121: AND EXISTS (SELECT 'x'
122: FROM xla_aad_line_defn_assgns xal
123: , xla_line_defn_jlt_assgns xld
124: WHERE xld.application_id = xal.application_id
125: AND xld.amb_context_code = xal.amb_context_code
126: AND xld.event_class_code = xal.event_class_code

Line 203: FROM xla_aad_line_defn_assgns xal

199: WHERE xpa.application_id = p_application_id
200: AND xpa.event_class_code = p_event_class_code
201: AND xpa.validation_status_code <> 'N'
202: AND EXISTS (SELECT 'x'
203: FROM xla_aad_line_defn_assgns xal
204: , xla_line_defn_jlt_assgns xja
205: WHERE xja.application_id = xal.application_id
206: AND xja.amb_context_code = xal.amb_context_code
207: AND xja.event_class_code = xal.event_class_code

Line 223: FROM xla_aad_line_defn_assgns xal

219: SET compile_status_code = 'N'
220: WHERE xpr.application_id = p_application_id
221: AND xpr.compile_status_code <> 'N'
222: AND EXISTS (SELECT 'x'
223: FROM xla_aad_line_defn_assgns xal
224: , xla_line_defn_jlt_assgns xja
225: WHERE xja.application_id = xal.application_id
226: AND xja.amb_context_code = xal.amb_context_code
227: AND xja.event_class_code = xal.event_class_code

Line 311: FROM xla_aad_line_defn_assgns xal

307: WHERE xpa.application_id = p_application_id
308: AND xpa.event_class_code = p_event_class_code
309: AND xpa.accounting_required_flag = 'Y'
310: AND EXISTS (SELECT 'x'
311: FROM xla_aad_line_defn_assgns xal
312: , xla_line_defn_jlt_assgns xld
313: WHERE xld.application_id = xal.application_id
314: AND xld.amb_context_code = xal.amb_context_code
315: AND xld.event_class_code = xal.event_class_code

Line 379: , xla_aad_line_defn_assgns xal

375: AND xld.event_class_code = p_event_class_code
376: AND xld.validation_status_code <> 'N'
377: AND EXISTS (SELECT 'x'
378: FROM xla_prod_acct_headers xpa
379: , xla_aad_line_defn_assgns xal
380: , xla_line_defn_jlt_assgns xja
381: WHERE xld.application_id = xja.application_id
382: AND xld.amb_context_code = xja.amb_context_code
383: AND xld.event_class_code = xja.event_class_code

Line 408: FROM xla_aad_line_defn_assgns xal

404: AND xpa.event_class_code = p_event_class_code
405: AND xpa.accounting_required_flag = 'Y'
406: AND xpa.validation_status_code <> 'N'
407: AND EXISTS (SELECT 'x'
408: FROM xla_aad_line_defn_assgns xal
409: , xla_line_defn_jlt_assgns xld
410: WHERE xld.application_id = xal.application_id
411: AND xld.amb_context_code = xal.amb_context_code
412: AND xld.event_class_code = xal.event_class_code

Line 429: , xla_aad_line_defn_assgns xal

425: WHERE xpr.application_id = p_application_id
426: AND xpr.compile_status_code <> 'N'
427: AND EXISTS (SELECT 'x'
428: FROM xla_prod_acct_headers xpa
429: , xla_aad_line_defn_assgns xal
430: , xla_line_defn_jlt_assgns xja
431: WHERE xja.application_id = xal.application_id
432: AND xja.amb_context_code = xal.amb_context_code
433: AND xja.event_class_code = xal.event_class_code

Line 524: FROM xla_aad_line_defn_assgns xal

520: FROM xla_prod_acct_headers xpa
521: WHERE xpa.application_id = p_application_id
522: AND xpa.event_class_code = p_event_class_code
523: AND EXISTS (SELECT 'x'
524: FROM xla_aad_line_defn_assgns xal
525: , xla_line_defn_jlt_assgns xld
526: , xla_jlt_acct_attrs xja
527: WHERE xja.application_id = p_application_id
528: AND xja.event_class_code = p_event_class_code

Line 626: FROM xla_aad_line_defn_assgns xal

622: WHERE xpa.application_id = p_application_id
623: AND xpa.event_class_code = p_event_class_code
624: AND xpa.validation_status_code <> 'N'
625: AND EXISTS (SELECT 'X'
626: FROM xla_aad_line_defn_assgns xal
627: , xla_line_defn_jlt_assgns xld
628: , xla_jlt_acct_attrs xja
629: WHERE xja.application_id = p_application_id
630: AND xja.event_class_code = p_event_class_code

Line 656: FROM xla_aad_line_defn_assgns xal

652: SET compile_status_code = 'N'
653: WHERE xpr.application_id = p_application_id
654: AND xpr.compile_status_code <> 'N'
655: AND EXISTS (SELECT 'X'
656: FROM xla_aad_line_defn_assgns xal
657: , xla_line_defn_jlt_assgns xld
658: , xla_jlt_acct_attrs xja
659: WHERE xja.application_id = p_application_id
660: AND xja.event_class_code = p_event_class_code

Line 911: FROM xla_aad_line_defn_assgns xal

907: FROM xla_prod_acct_headers xpa
908: WHERE xpa.application_id = p_application_id
909: AND xpa.event_class_code = p_event_class_code
910: AND EXISTS (SELECT 'x'
911: FROM xla_aad_line_defn_assgns xal
912: , xla_line_defn_jlt_assgns xja
913: , xla_jlt_acct_attrs xaa
914: WHERE xaa.application_id = p_application_id
915: AND xaa.event_class_code = p_event_class_code

Line 1020: FROM xla_aad_line_defn_assgns xal

1016: WHERE xpa.application_id = p_application_id
1017: AND xpa.event_class_code = p_event_class_code
1018: AND xpa.validation_status_code <> 'N'
1019: AND EXISTS (SELECT 'x'
1020: FROM xla_aad_line_defn_assgns xal
1021: , xla_line_defn_jlt_assgns xja
1022: , xla_jlt_acct_attrs xaa
1023: WHERE xaa.application_id = p_application_id
1024: AND xaa.event_class_code = p_event_class_code

Line 1054: FROM xla_aad_line_defn_assgns xal

1050: SET compile_status_code = 'N'
1051: WHERE xpr.application_id = p_application_id
1052: AND xpr.compile_status_code <> 'N'
1053: AND EXISTS (SELECT 'x'
1054: FROM xla_aad_line_defn_assgns xal
1055: , xla_line_defn_jlt_assgns xja
1056: , xla_jlt_acct_attrs xaa
1057: WHERE xaa.application_id = p_application_id
1058: AND xaa.event_class_code = p_event_class_code