DBA Data[Home] [Help]

APPS.FV_GTAS_GL_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 33: doc_num xla_transaction_entities.transaction_number%TYPE);

29: reported_status VARCHAR2(1),
30: record_category fv_gtas_activity_balances.record_category%TYPE,
31: fed_nonfed_code fv_gtas_activity_balances.fed_non_fed%TYPE,
32: party_line_amount NUMBER,
33: doc_num xla_transaction_entities.transaction_number%TYPE);
34: TYPE party_info_table
35: IS TABLE OF party_info_rec INDEX BY BINARY_INTEGER;
36:
37: PROCEDURE get_system_attributes;

Line 1082: xla_transaction_entities xte

1078: FROM gl_import_references gli,
1079: xla_ae_lines xl ,
1080: xla_ae_headers xh ,
1081: xla_distribution_links xd,
1082: xla_transaction_entities xte
1083: WHERE gli.je_batch_id = p_je_batch_id
1084: AND gli.je_header_id = p_je_header_id
1085: AND gli.je_line_num = p_je_line_num
1086: AND xl.gl_sl_link_id = gli.gl_sl_link_id

Line 1107: l_be_doc_num xla_transaction_entities.transaction_number%TYPE;

1103: l_exception_category fv_gtas_exceptions.exception_category%TYPE;
1104: l_module_name VARCHAR2(200) := g_module_name||'GET_AUTHORITY_TYPE_CODE';
1105: l_auth_select VARCHAR2(200);
1106: l_auth_type_code_count NUMBER;
1107: l_be_doc_num xla_transaction_entities.transaction_number%TYPE;
1108: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;
1109:
1110:
1111: BEGIN

Line 1579: xla_transaction_entities xte

1575: xte.transaction_number
1576: FROM gl_import_references i,
1577: xla_ae_lines ael,
1578: xla_ae_headers aeh,
1579: xla_transaction_entities xte
1580: WHERE i.je_batch_id = p_je_batch_id
1581: AND i.je_header_id = p_je_header_id
1582: AND i.je_line_num = p_je_line_num
1583: AND i.gl_sl_link_id = ael.gl_sl_link_id

Line 1602: xla_transaction_entities xte

1598: xla_ae_headers aeh ,
1599: pa_draft_revenues_all pdr,
1600: pa_agreements_all agr ,
1601: pa_project_customers pc,
1602: xla_transaction_entities xte
1603: WHERE je.je_header_id = gir.je_header_id
1604: AND je.je_line_num = gir.je_line_num
1605: AND ael.gl_sl_link_id = gir.gl_sl_link_id
1606: AND ael.ae_header_id = aeh.ae_header_id

Line 1627: xla_transaction_entities xte,

1623: FROM gl_import_references gli,
1624: xla_ae_lines xl ,
1625: xla_ae_headers xh ,
1626: xla_distribution_links xd,
1627: xla_transaction_entities xte,
1628: fv_be_trx_dtls bd,
1629: fv_be_trx_hdrs bh
1630: WHERE gli.je_batch_id = p_je_batch_id
1631: AND gli.je_header_id = p_je_header_id