APPS.XLA_MPA_ACCRUAL_RPRTG_PKG dependencies on XLA_LOOKUPS

Line 305: ,xla_lookups lk1

301: ,xla_gl_ledgers_v xgl
302: ,xla_event_classes_tl xec
303: ,xla_event_types_b xet
304: ,xla_subledgers xls
305: ,xla_lookups lk1
306: ,xla_lookups lk2
307: ,xla_lookups lk3
308: WHERE xgl.ledger_id = xah.ledger_id
309: AND xec.application_id = xet.application_id

Line 306: ,xla_lookups lk2

302: ,xla_event_classes_tl xec
303: ,xla_event_types_b xet
304: ,xla_subledgers xls
305: ,xla_lookups lk1
306: ,xla_lookups lk2
307: ,xla_lookups lk3
308: WHERE xgl.ledger_id = xah.ledger_id
309: AND xec.application_id = xet.application_id
310: AND xec.event_class_code = xet.event_class_code

Line 307: ,xla_lookups lk3

303: ,xla_event_types_b xet
304: ,xla_subledgers xls
305: ,xla_lookups lk1
306: ,xla_lookups lk2
307: ,xla_lookups lk3
308: WHERE xgl.ledger_id = xah.ledger_id
309: AND xec.application_id = xet.application_id
310: AND xec.event_class_code = xet.event_class_code
311: AND xec.language = USERENV(''LANG'')

Line 359: ,xla_lookups lk1

355: FROM xla_ae_headers xah
356: ,xla_ae_lines xal
357: ,xla_gl_ledgers_v xgl
358: ,xla_subledgers xls
359: ,xla_lookups lk1
360: ,xla_lookups lk2
361: ,xla_lookups lk3
362: ,xla_lookups lk4
363: WHERE xgl.ledger_id = xah.ledger_id

Line 360: ,xla_lookups lk2

356: ,xla_ae_lines xal
357: ,xla_gl_ledgers_v xgl
358: ,xla_subledgers xls
359: ,xla_lookups lk1
360: ,xla_lookups lk2
361: ,xla_lookups lk3
362: ,xla_lookups lk4
363: WHERE xgl.ledger_id = xah.ledger_id
364: AND xah.gl_transfer_status_code = ''Y''

Line 361: ,xla_lookups lk3

357: ,xla_gl_ledgers_v xgl
358: ,xla_subledgers xls
359: ,xla_lookups lk1
360: ,xla_lookups lk2
361: ,xla_lookups lk3
362: ,xla_lookups lk4
363: WHERE xgl.ledger_id = xah.ledger_id
364: AND xah.gl_transfer_status_code = ''Y''
365: AND xal.application_id = xah.application_id

Line 362: ,xla_lookups lk4

358: ,xla_subledgers xls
359: ,xla_lookups lk1
360: ,xla_lookups lk2
361: ,xla_lookups lk3
362: ,xla_lookups lk4
363: WHERE xgl.ledger_id = xah.ledger_id
364: AND xah.gl_transfer_status_code = ''Y''
365: AND xal.application_id = xah.application_id
366: AND xal.ae_header_id = xah.ae_header_id

Line 436: ,xla_lookups lk1

432: ,xla_transaction_entities ent
433: ,xla_event_classes_tl xec
434: ,xla_gl_ledgers_v gld
435: ,xla_product_rules_tl xpr
436: ,xla_lookups lk1
437: ,xla_lookups lk2
438: ,xla_lookups lk3
439: ,fnd_document_sequences seq
440: ,fun_seq_versions seqv2

Line 437: ,xla_lookups lk2

433: ,xla_event_classes_tl xec
434: ,xla_gl_ledgers_v gld
435: ,xla_product_rules_tl xpr
436: ,xla_lookups lk1
437: ,xla_lookups lk2
438: ,xla_lookups lk3
439: ,fnd_document_sequences seq
440: ,fun_seq_versions seqv2
441: ,fun_seq_versions seqv3 ';

Line 438: ,xla_lookups lk3

434: ,xla_gl_ledgers_v gld
435: ,xla_product_rules_tl xpr
436: ,xla_lookups lk1
437: ,xla_lookups lk2
438: ,xla_lookups lk3
439: ,fnd_document_sequences seq
440: ,fun_seq_versions seqv2
441: ,fun_seq_versions seqv3 ';
442:

Line 524: ,xla_lookups lk1

520: ,xla_event_classes_tl xec
521: ,xla_transaction_entities ent
522: ,xla_gl_ledgers_v gld
523: ,xla_product_rules_tl xpr
524: ,xla_lookups lk1
525: ,xla_lookups lk2
526: ,xla_lookups lk3
527: ,xla_ae_lines xal
528: ,fnd_document_sequences seq

Line 525: ,xla_lookups lk2

521: ,xla_transaction_entities ent
522: ,xla_gl_ledgers_v gld
523: ,xla_product_rules_tl xpr
524: ,xla_lookups lk1
525: ,xla_lookups lk2
526: ,xla_lookups lk3
527: ,xla_ae_lines xal
528: ,fnd_document_sequences seq
529: ,fun_seq_versions seqv2

Line 526: ,xla_lookups lk3

522: ,xla_gl_ledgers_v gld
523: ,xla_product_rules_tl xpr
524: ,xla_lookups lk1
525: ,xla_lookups lk2
526: ,xla_lookups lk3
527: ,xla_ae_lines xal
528: ,fnd_document_sequences seq
529: ,fun_seq_versions seqv2
530: ,fun_seq_versions seqv3

Line 618: ,xla_lookups lk1

614: ,xla_event_classes_tl xec
615: ,xla_gl_ledgers_v gld
616: ,xla_transaction_entities ent
617: ,xla_product_rules_tl xpr
618: ,xla_lookups lk1
619: ,xla_lookups lk2
620: ,xla_lookups lk3
621: ,xla_ae_lines xal
622: ,fnd_document_sequences seq

Line 619: ,xla_lookups lk2

615: ,xla_gl_ledgers_v gld
616: ,xla_transaction_entities ent
617: ,xla_product_rules_tl xpr
618: ,xla_lookups lk1
619: ,xla_lookups lk2
620: ,xla_lookups lk3
621: ,xla_ae_lines xal
622: ,fnd_document_sequences seq
623: ,fun_seq_versions seqv2

Line 620: ,xla_lookups lk3

616: ,xla_transaction_entities ent
617: ,xla_product_rules_tl xpr
618: ,xla_lookups lk1
619: ,xla_lookups lk2
620: ,xla_lookups lk3
621: ,xla_ae_lines xal
622: ,fnd_document_sequences seq
623: ,fun_seq_versions seqv2
624: ,fun_seq_versions seqv3

Line 770: FROM xla_lookups

766: BEGIN
767:
768: SELECT meaning
769: INTO l_create_accounting_flag
770: FROM xla_lookups
771: WHERE lookup_type = 'XLA_YES_NO'
772: AND lookup_code = p_accounting_flag;
773: EXCEPTION
774: WHEN NO_DATA_FOUND THEN

Line 826: FROM xla_lookups

822:
823:
824: SELECT meaning
825: INTO l_report_style
826: FROM xla_lookups
827: WHERE lookup_code = 'D'
828: AND lookup_type = 'XLA_ACCT_TRANSFER_MODE';
829:
830: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 838: FROM xla_lookups

834:
835: BEGIN
836: SELECT meaning
837: INTO l_errors_only_flag
838: FROM xla_lookups
839: WHERE lookup_code = p_errors_only_flag
840: AND lookup_type = 'XLA_YES_NO';
841:
842: EXCEPTION

Line 857: FROM xla_lookups

853: BEGIN
854:
855: SELECT meaning
856: INTO l_transfer_to_gl_flag
857: FROM xla_lookups
858: WHERE lookup_type = 'XLA_YES_NO'
859: AND lookup_code = p_transfer_flag;
860: EXCEPTION
861: WHEN NO_DATA_FOUND THEN

Line 873: FROM xla_lookups

869:
870: BEGIN
871: SELECT MEANING
872: INTO l_post_in_gl_flag
873: FROM xla_lookups
874: WHERE lookup_type = 'XLA_YES_NO'
875: AND lookup_code = p_gl_posting_flag;
876:
877: EXCEPTION