DBA Data[Home] [Help]

APPS.IGI_STP_CREATE_PCK_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 469: ra_cust_trx_line_gl_dist dist,

465: THEN
466: SELECT dist.code_combination_id
467: INTO l_rec_ccid
468: FROM ra_customer_trx trx,
469: ra_cust_trx_line_gl_dist dist,
470: igi_stp_candidates candidates
471: WHERE dist.customer_trx_id = trx.customer_trx_id
472: AND dist.account_class = 'REC'
473: AND trx.trx_number = candidates.trx_number

Line 1038: ra_cust_trx_line_gl_dist dist,

1034: IF l_rec_ccid is null THEN
1035: SELECT dist.code_combination_id
1036: INTO l_rec_ccid
1037: FROM ra_customer_trx trx,
1038: ra_cust_trx_line_gl_dist dist,
1039: igi_stp_candidates candidates
1040: WHERE dist.customer_trx_id = trx.customer_trx_id
1041: AND dist.account_class = 'REC'
1042: AND trx.trx_number = candidates.trx_number