DBA Data[Home] [Help]

APPS.XLA_EVT_CLASS_ACCT_ATTRS_PKG dependencies on XLA_LINE_DEFN_JLT_ASSGNS

Line 123: , xla_line_defn_jlt_assgns xld

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
127: AND xld.event_type_code = xal.event_type_code

Line 189: FROM xla_line_defn_jlt_assgns xja

185: WHERE xld.application_id = p_application_id
186: AND xld.event_class_code = p_event_class_code
187: AND xld.validation_status_code <> 'N'
188: AND EXISTS (SELECT 'X'
189: FROM xla_line_defn_jlt_assgns xja
190: WHERE xld.application_id = xja.application_id
191: AND xld.amb_context_code = xja.amb_context_code
192: AND xld.event_class_code = xja.event_class_code
193: AND xld.event_type_code = xja.event_type_code

Line 204: , xla_line_defn_jlt_assgns xja

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
208: AND xja.event_type_code = xal.event_type_code

Line 224: , xla_line_defn_jlt_assgns xja

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
228: AND xja.event_type_code = xal.event_type_code

Line 312: , xla_line_defn_jlt_assgns xld

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
316: AND xld.event_type_code = xal.event_type_code

Line 380: , xla_line_defn_jlt_assgns xja

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
384: AND xld.event_type_code = xja.event_type_code

Line 409: , xla_line_defn_jlt_assgns xld

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
413: AND xld.event_type_code = xal.event_type_code

Line 430: , xla_line_defn_jlt_assgns xja

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
434: AND xja.event_type_code = xal.event_type_code

Line 525: , xla_line_defn_jlt_assgns xld

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
529: AND xja.accounting_attribute_code = p_accounting_attribute_code

Line 602: FROM xla_line_defn_jlt_assgns xld

598: WHERE xpa.application_id = p_application_id
599: AND xpa.event_class_code = p_event_class_code
600: AND xpa.validation_status_code <> 'N'
601: AND EXISTS (SELECT 'X'
602: FROM xla_line_defn_jlt_assgns xld
603: , xla_jlt_acct_attrs xja
604: WHERE xja.application_id = p_application_id
605: AND xja.event_class_code = p_event_class_code
606: AND xja.accounting_attribute_code = p_accounting_attribute_code

Line 627: , xla_line_defn_jlt_assgns xld

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
631: AND xja.accounting_attribute_code = p_accounting_attribute_code

Line 657: , xla_line_defn_jlt_assgns xld

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
661: AND xja.accounting_attribute_code = p_accounting_attribute_code

Line 912: , xla_line_defn_jlt_assgns xja

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
916: AND xaa.accounting_attribute_code = p_accounting_attribute_code

Line 992: FROM xla_line_defn_jlt_assgns xja

988: WHERE xld.application_id = p_application_id
989: AND xld.event_class_code = p_event_class_code
990: AND xld.validation_status_code <> 'N'
991: AND EXISTS (SELECT 'X'
992: FROM xla_line_defn_jlt_assgns xja
993: , xla_jlt_acct_attrs xaa
994: WHERE xaa.application_id = p_application_id
995: AND xaa.event_class_code = p_event_class_code
996: AND xaa.accounting_attribute_code = p_accounting_attribute_code

Line 1021: , xla_line_defn_jlt_assgns xja

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
1025: AND xaa.accounting_attribute_code = p_accounting_attribute_code

Line 1055: , xla_line_defn_jlt_assgns xja

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
1059: AND xaa.accounting_attribute_code = p_accounting_attribute_code