DBA Data[Home] [Help]

APPS.JA_CN_GL_INTER_VALID_PKG dependencies on HZ_PARTIES

Line 1325: l_trx_send_name hz_parties.party_name%TYPE;

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;
1328: l_trx_desc fun_trx_headers.description%TYPE;
1329: l_trx_line_num varchar2(20);

Line 1326: l_trx_recv_name hz_parties.party_name%TYPE;

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;
1328: l_trx_desc fun_trx_headers.description%TYPE;
1329: l_trx_line_num varchar2(20);
1330: l_trx_line_sob NUMBER;

Line 1432: ,HZ_PARTIES party_init

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
1434: --,JA_CN_DFF_ASSIGNMENTS dff
1435: WHERE trxh.batch_id=trxb.batch_id
1436: AND trxb.trx_type_id=trxtype.trx_type_id

Line 1433: ,HZ_PARTIES party_reci

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
1434: --,JA_CN_DFF_ASSIGNMENTS dff
1435: WHERE trxh.batch_id=trxb.batch_id
1436: AND trxb.trx_type_id=trxtype.trx_type_id
1437: AND party_init.party_id=trxh.initiator_id