DBA Data[Home] [Help]

APPS.JA_CN_GL_INTER_VALID_PKG dependencies on HZ_PARTIES

Line 1362: l_trx_send_name hz_parties.party_name%TYPE;

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

Line 1363: l_trx_recv_name hz_parties.party_name%TYPE;

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;
1365: l_trx_desc fun_trx_headers.description%TYPE;
1366: l_trx_line_num varchar2(20);
1367: l_trx_line_sob NUMBER;

Line 1469: ,HZ_PARTIES party_init

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
1471: --,JA_CN_DFF_ASSIGNMENTS dff
1472: WHERE trxh.batch_id=trxb.batch_id
1473: AND trxb.trx_type_id=trxtype.trx_type_id

Line 1470: ,HZ_PARTIES party_reci

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
1471: --,JA_CN_DFF_ASSIGNMENTS dff
1472: WHERE trxh.batch_id=trxb.batch_id
1473: AND trxb.trx_type_id=trxtype.trx_type_id
1474: AND party_init.party_id=trxh.initiator_id