APPS.JA_CN_CFS_CLT_SLA_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 522: l_line_org_id xla_transaction_entities.security_id_int_1%TYPE;

518: --l_source fnd_application.application_short_name%TYPE;
519: l_source_id fnd_application.application_id%TYPE;
520:
521: -- the interim variables for activities all table
522: l_line_org_id xla_transaction_entities.security_id_int_1%TYPE;
523: l_mapping_org_id NUMBER;
524: l_detailed_cfs_item ja_cn_cfs_activities_all.detailed_cfs_item%type;
525: l_event_class_code ja_cn_cfs_item_mapping_hdrs.event_class_code%TYPE;
526:

Line 900: FROM XLA_TRANSACTION_ENTITIES xte, xla_ae_headers xah

896: --Get org id of the current sla ae line
897: begin
898: Select xte.SECURITY_ID_INT_1
899: Into l_line_org_id
900: FROM XLA_TRANSACTION_ENTITIES xte, xla_ae_headers xah
901: Where xte.entity_id = xah.entity_id
902: And xte.application_id = xah.application_id
903: And xah.ae_header_id = l_ae_header_id
904: AND xah.application_id = l_application_id;