[Home] [Help]
907: IS
908: SELECT xal.code_combination_id
909: FROM mtl_transaction_accounts mta,
910: xla_distribution_links xdl,
911: xla_ae_lines xal,
912: xla_ae_headers xah
913: WHERE mta.transaction_id = p_mtl_txn_id
914: AND mta.accounting_line_type = p_acct_line_type
915: AND nvl(mta.cost_element_id,1) = p_cost_element_id
923: /*
924: SELECT xlael.code_combination_id
925: FROM xla_transaction_entities xlte,
926: xla_ae_headers xlaeh,
927: xla_ae_lines xlael,
928: xla_distribution_links xdl,
929: mtl_transaction_accounts mta
930: WHERE xlte.application_id = l_application_id
931: AND xlte.entity_code = l_entity_code
2772: CURSOR sla_ccid_cur IS
2773: SELECT xlael.code_combination_id
2774: FROM xla_transaction_entities xlte,
2775: xla_ae_headers xlaeh,
2776: xla_ae_lines xlael
2777: WHERE xlte.application_id = l_application_id
2778: AND xlte.entity_code = l_entity_code
2779: AND xlte.source_id_int_1 = p_invoice_id
2780: AND xlaeh.ledger_id = l_ledger_id
2849: /* CURSOR sla_ccid_cur IS
2850: SELECT xlael.code_combination_id
2851: FROM xla_transaction_entities xlte,
2852: xla_ae_headers xlaeh,
2853: xla_ae_lines xlael
2854: WHERE xlte.application_id = l_application_id
2855: AND xlte.entity_code = l_entity_code
2856: AND xlte.source_id_int_1 = p_invoice_id
2857: AND xlaeh.ledger_id = l_ledger_id
2864: CURSOR sla_ccid_cur IS
2865: SELECT xlael.code_combination_id
2866: FROM xla_transaction_entities xlte,
2867: xla_ae_headers xlaeh,
2868: xla_ae_lines xlael,
2869: xla_distribution_links xdl,
2870: ap_invoice_distributions_all aida
2871: WHERE xlte.application_id = l_application_id
2872: AND xlte.entity_code = l_entity_code
2887: CURSOR sal_ccid_self_assessed_cur IS
2888: SELECT xlael.code_combination_id
2889: FROM xla_transaction_entities xlte,
2890: xla_ae_headers xlaeh,
2891: xla_ae_lines xlael,
2892: xla_distribution_links xdl,
2893: AP_SELF_ASSESSED_TAX_DIST_all aida
2894: WHERE xlte.application_id = l_application_id
2895: AND xlte.entity_code = l_entity_code