APPS.JA_CN_GL_INTER_VALID_PKG dependencies on FUN_TRX_HEADERS

Line 286: , fun_trx_headers trxh

282: ) cash_related_item*/
283: SELECT global_attribute6 cash_related_item
284: INTO l_cash_flow_item_from_GL
285: FROM gl_je_lines jel
286: , fun_trx_headers trxh
287: , fun_trx_lines trxl
288: , fun_dist_lines distl
289: --,ja_cn_dff_assignments dffa
290: WHERE distl.dist_id = l_jt_id -- transaction header id

Line 1330: --l_status FUN_TRX_HEADERS.STATUS%TYPE := P_STATUS;

1326: l_period_to gl_periods.period_name%TYPE := P_END_PERIOD;
1327: l_com_seg VARCHAR2(25) := P_COM_SEG; --Added for CNAO Enhancement
1328: l_ledger_name VARCHAR2(30);
1329: --l_com_segment VARCHAR2(150) := P_COM_SEGMENT;
1330: --l_status FUN_TRX_HEADERS.STATUS%TYPE := P_STATUS;
1331: --l_sts_settle VARCHAR2(200) := '';
1332:
1333: l_xml_item XMLTYPE;
1334: l_xml_line_items XMLTYPE;

Line 1359: l_trx_id fun_trx_headers.Trx_Id%TYPE;

1355: l_trxb_id fun_trx_batches.batch_id%TYPE;
1356: l_trxb_num fun_trx_batches.batch_number%TYPE;
1357:
1358: -- trx_headers
1359: l_trx_id fun_trx_headers.Trx_Id%TYPE;
1360: l_trx_num fun_trx_headers.Trx_Number%TYPE;
1361: l_trx_type fun_trx_types_tl.trx_type_name%TYPE;
1362: l_trx_send_name hz_parties.party_name%TYPE;
1363: l_trx_recv_name hz_parties.party_name%TYPE;

Line 1360: l_trx_num fun_trx_headers.Trx_Number%TYPE;

1356: l_trxb_num fun_trx_batches.batch_number%TYPE;
1357:
1358: -- trx_headers
1359: l_trx_id fun_trx_headers.Trx_Id%TYPE;
1360: l_trx_num fun_trx_headers.Trx_Number%TYPE;
1361: l_trx_type fun_trx_types_tl.trx_type_name%TYPE;
1362: l_trx_send_name hz_parties.party_name%TYPE;
1363: l_trx_recv_name hz_parties.party_name%TYPE;
1364: l_trx_gl_date fun_trx_batches.gl_date%TYPE;

Line 1365: l_trx_desc fun_trx_headers.description%TYPE;

1361: l_trx_type fun_trx_types_tl.trx_type_name%TYPE;
1362: l_trx_send_name hz_parties.party_name%TYPE;
1363: l_trx_recv_name hz_parties.party_name%TYPE;
1364: l_trx_gl_date fun_trx_batches.gl_date%TYPE;
1365: l_trx_desc fun_trx_headers.description%TYPE;
1366: l_trx_line_num varchar2(20);
1367: l_trx_line_sob NUMBER;
1368: l_trx_line_le NUMBER;
1369: l_trx_line_com_seg fun_trx_batches.description%TYPE;

Line 1466: FROM FUN_TRX_HEADERS trxh

1462: 'ATTRIBUTE9',trxh.attribute9, 'ATTRIBUTE10',trxh.attribute10, 'ATTRIBUTE11',trxh.attribute11,
1463: 'ATTRIBUTE12',trxh.attribute12, 'ATTRIBUTE13',trxh.attribute13, 'ATTRIBUTE14',trxh.attribute14,
1464: 'ATTRIBUTE15',trxh.attribute15)
1465: , '') trxh_cash_related_item*/
1466: FROM FUN_TRX_HEADERS trxh
1467: ,FUN_TRX_BATCHES trxb
1468: ,FUN_TRX_TYPES_TL trxtype
1469: ,HZ_PARTIES party_init
1470: ,HZ_PARTIES party_reci

Line 1559: SELECT * FROM FUN_TRX_HEADERS trxh

1555: --Added for CNAO Enhancement end
1556: -- Fix bug#7487439 added begin
1557: AND EXISTS
1558: (
1559: SELECT * FROM FUN_TRX_HEADERS trxh
1560: ,FUN_TRX_BATCHES trxb
1561: WHERE trxh.batch_id=trxb.batch_id
1562: AND trxh.invoice_flag='N'
1563: AND trxh.trx_id=l_trx_id --using variable l_trx_id