DBA Data[Home] [Help]

APPS.OKL_CURE_RECON_PVT dependencies on RA_CUST_TRX_TYPES

Line 929: FROM ra_cust_trx_types

925: -- vdamerla added cursor to get the cust_trx_type_id
926: CURSOR ra_cust_csr
927: IS
928: SELECT cust_trx_type_id l_cust_trx_type_id
929: FROM ra_cust_trx_types
930: WHERE name = 'Invoice-OKL';
931:
932: -- R12 Change - END
933:

Line 1983: FROM ra_cust_trx_types

1979:
1980: CURSOR ra_cust_csr
1981: IS
1982: SELECT cust_trx_type_id l_cust_trx_type_id
1983: FROM ra_cust_trx_types
1984: WHERE name = 'Invoice-OKL';
1985:
1986: ra_cust_rec ra_cust_csr%ROWTYPE;
1987:

Line 2305: l_acc_gen_primary_key_tbl(3).source_table := 'RA_CUST_TRX_TYPES';

2301: FETCH custBillTo_csr INTO l_custBillTo_rec;
2302: CLOSE custBillTo_csr;
2303: l_acc_gen_primary_key_tbl(2).primary_key_column := l_custBillTo_rec.cust_acct_site_id;
2304:
2305: l_acc_gen_primary_key_tbl(3).source_table := 'RA_CUST_TRX_TYPES';
2306: OPEN ra_cust_csr;
2307: FETCH ra_cust_csr INTO ra_cust_rec;
2308: IF ( ra_cust_csr%NOTFOUND ) THEN
2309: l_acc_gen_primary_key_tbl(3).primary_key_column := '';