DBA Data[Home] [Help]

APPS.OKL_FUNDING_PVT dependencies on RA_CUST_TRX_TYPES

Line 1328: --RA_CUST_TRX_TYPES

1324: and pty.chr_id = chr.id
1325: and chr.id = p_chr_id;
1326:
1327:
1328: --RA_CUST_TRX_TYPES
1329:
1330: Cursor ra_cust_trx_types_csr( p_chr_id NUMBER) IS
1331: select cust_trx_type_id
1332: from ra_cust_trx_types

Line 1330: Cursor ra_cust_trx_types_csr( p_chr_id NUMBER) IS

1326:
1327:
1328: --RA_CUST_TRX_TYPES
1329:
1330: Cursor ra_cust_trx_types_csr( p_chr_id NUMBER) IS
1331: select cust_trx_type_id
1332: from ra_cust_trx_types
1333: where name = 'Invoice-OKL';
1334:

Line 1332: from ra_cust_trx_types

1328: --RA_CUST_TRX_TYPES
1329:
1330: Cursor ra_cust_trx_types_csr( p_chr_id NUMBER) IS
1331: select cust_trx_type_id
1332: from ra_cust_trx_types
1333: where name = 'Invoice-OKL';
1334:
1335:
1336: --AR_SITE_USES_V

Line 1663: OPEN ra_cust_trx_types_csr (l_chr_id);

1659: CLOSE salesP_csr;
1660: l_acc_gen_primary_key_tbl(cnt).acc_gen_key_tbl(3).source_table := 'JTF_RS_SALESREPS_MO_V';
1661: l_acc_gen_primary_key_tbl(cnt).acc_gen_key_tbl(3).primary_key_column := l_sales_id;
1662:
1663: OPEN ra_cust_trx_types_csr (l_chr_id);
1664: FETCH ra_cust_trx_types_csr INTO l_cust_trx_type_id;
1665: CLOSE ra_cust_trx_types_csr;
1666: l_acc_gen_primary_key_tbl(cnt).acc_gen_key_tbl(4).source_table := 'RA_CUST_TRX_TYPES';
1667: l_acc_gen_primary_key_tbl(cnt).acc_gen_key_tbl(4).primary_key_column := l_cust_trx_type_id;

Line 1664: FETCH ra_cust_trx_types_csr INTO l_cust_trx_type_id;

1660: l_acc_gen_primary_key_tbl(cnt).acc_gen_key_tbl(3).source_table := 'JTF_RS_SALESREPS_MO_V';
1661: l_acc_gen_primary_key_tbl(cnt).acc_gen_key_tbl(3).primary_key_column := l_sales_id;
1662:
1663: OPEN ra_cust_trx_types_csr (l_chr_id);
1664: FETCH ra_cust_trx_types_csr INTO l_cust_trx_type_id;
1665: CLOSE ra_cust_trx_types_csr;
1666: l_acc_gen_primary_key_tbl(cnt).acc_gen_key_tbl(4).source_table := 'RA_CUST_TRX_TYPES';
1667: l_acc_gen_primary_key_tbl(cnt).acc_gen_key_tbl(4).primary_key_column := l_cust_trx_type_id;
1668:

Line 1665: CLOSE ra_cust_trx_types_csr;

1661: l_acc_gen_primary_key_tbl(cnt).acc_gen_key_tbl(3).primary_key_column := l_sales_id;
1662:
1663: OPEN ra_cust_trx_types_csr (l_chr_id);
1664: FETCH ra_cust_trx_types_csr INTO l_cust_trx_type_id;
1665: CLOSE ra_cust_trx_types_csr;
1666: l_acc_gen_primary_key_tbl(cnt).acc_gen_key_tbl(4).source_table := 'RA_CUST_TRX_TYPES';
1667: l_acc_gen_primary_key_tbl(cnt).acc_gen_key_tbl(4).primary_key_column := l_cust_trx_type_id;
1668:
1669: --start:| 05-Jul-2007 cklee Fixed Accounting call issue: assigned the following: |

Line 1666: l_acc_gen_primary_key_tbl(cnt).acc_gen_key_tbl(4).source_table := 'RA_CUST_TRX_TYPES';

1662:
1663: OPEN ra_cust_trx_types_csr (l_chr_id);
1664: FETCH ra_cust_trx_types_csr INTO l_cust_trx_type_id;
1665: CLOSE ra_cust_trx_types_csr;
1666: l_acc_gen_primary_key_tbl(cnt).acc_gen_key_tbl(4).source_table := 'RA_CUST_TRX_TYPES';
1667: l_acc_gen_primary_key_tbl(cnt).acc_gen_key_tbl(4).primary_key_column := l_cust_trx_type_id;
1668:
1669: --start:| 05-Jul-2007 cklee Fixed Accounting call issue: assigned the following: |
1670: --| l_acc_gen_primary_key_tbl(cnt).source_id := r_this.id; |