APPS.JA_CN_GL_INTER_VALID_PKG dependencies on FUN_TRX_HEADERS

Line 283: , fun_trx_headers trxh

279: 'ATTRIBUTE15',jel.attribute15)
280: ) cash_related_item
281: INTO l_cash_flow_item_from_GL
282: FROM gl_je_lines jel
283: , fun_trx_headers trxh
284: , fun_trx_lines trxl
285: , fun_dist_lines distl
286: ,ja_cn_dff_assignments dffa
287: WHERE distl.dist_id = l_jt_id -- transaction header id

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

1289: l_period_to gl_periods.period_name%TYPE := P_END_PERIOD;
1290: l_com_seg VARCHAR2(25) := P_COM_SEG; --Added for CNAO Enhancement
1291: l_ledger_name VARCHAR2(30);
1292: --l_com_segment VARCHAR2(150) := P_COM_SEGMENT;
1293: --l_status FUN_TRX_HEADERS.STATUS%TYPE := P_STATUS;
1294: --l_sts_settle VARCHAR2(200) := '';
1295:
1296: l_xml_item XMLTYPE;
1297: l_xml_line_items XMLTYPE;

Line 1322: l_trx_id fun_trx_headers.Trx_Id%TYPE;

1318: l_trxb_id fun_trx_batches.batch_id%TYPE;
1319: l_trxb_num fun_trx_batches.batch_number%TYPE;
1320:
1321: -- trx_headers
1322: l_trx_id fun_trx_headers.Trx_Id%TYPE;
1323: l_trx_num fun_trx_headers.Trx_Number%TYPE;
1324: l_trx_type fun_trx_types_tl.trx_type_name%TYPE;
1325: l_trx_send_name hz_parties.party_name%TYPE;
1326: l_trx_recv_name hz_parties.party_name%TYPE;

Line 1323: l_trx_num fun_trx_headers.Trx_Number%TYPE;

1319: l_trxb_num fun_trx_batches.batch_number%TYPE;
1320:
1321: -- trx_headers
1322: l_trx_id fun_trx_headers.Trx_Id%TYPE;
1323: l_trx_num fun_trx_headers.Trx_Number%TYPE;
1324: l_trx_type fun_trx_types_tl.trx_type_name%TYPE;
1325: l_trx_send_name hz_parties.party_name%TYPE;
1326: l_trx_recv_name hz_parties.party_name%TYPE;
1327: l_trx_gl_date fun_trx_batches.gl_date%TYPE;

Line 1328: l_trx_desc fun_trx_headers.description%TYPE;

1324: l_trx_type fun_trx_types_tl.trx_type_name%TYPE;
1325: l_trx_send_name hz_parties.party_name%TYPE;
1326: l_trx_recv_name hz_parties.party_name%TYPE;
1327: l_trx_gl_date fun_trx_batches.gl_date%TYPE;
1328: l_trx_desc fun_trx_headers.description%TYPE;
1329: l_trx_line_num varchar2(20);
1330: l_trx_line_sob NUMBER;
1331: l_trx_line_le NUMBER;
1332: l_trx_line_com_seg fun_trx_batches.description%TYPE;

Line 1429: FROM FUN_TRX_HEADERS trxh

1425: 'ATTRIBUTE9',trxh.attribute9, 'ATTRIBUTE10',trxh.attribute10, 'ATTRIBUTE11',trxh.attribute11,
1426: 'ATTRIBUTE12',trxh.attribute12, 'ATTRIBUTE13',trxh.attribute13, 'ATTRIBUTE14',trxh.attribute14,
1427: 'ATTRIBUTE15',trxh.attribute15)
1428: , '') trxh_cash_related_item*/
1429: FROM FUN_TRX_HEADERS trxh
1430: ,FUN_TRX_BATCHES trxb
1431: ,FUN_TRX_TYPES_TL trxtype
1432: ,HZ_PARTIES party_init
1433: ,HZ_PARTIES party_reci

Line 1522: SELECT * FROM FUN_TRX_HEADERS trxh

1518: --Added for CNAO Enhancement end
1519: -- Fix bug#7487439 added begin
1520: AND EXISTS
1521: (
1522: SELECT * FROM FUN_TRX_HEADERS trxh
1523: ,FUN_TRX_BATCHES trxb
1524: WHERE trxh.batch_id=trxb.batch_id
1525: AND trxh.invoice_flag='N'
1526: AND trxh.trx_id=l_trx_id --using variable l_trx_id