APPS.AR_DEPOSIT_API_PUB dependencies on RA_CUSTOMER_TRX_LINES

Line 506: ra_customer_trx_lines.customer_trx_line_id%type,

502: ra_customer_trx.trx_number%type,
503: X_new_customer_trx_id OUT NOCOPY
504: ra_customer_trx.customer_trx_id%type,
505: X_new_customer_trx_line_id OUT NOCOPY
506: ra_customer_trx_lines.customer_trx_line_id%type,
507: X_new_rowid OUT NOCOPY VARCHAR2 ) IS
508:
509: /*-----------------------------------------------------------------------+
510: | Local Variable Declarations and initializations |

Line 634: ra_customer_trx_lines.customer_trx_line_id%type;

630: l_dummy NUMBER;
631: l_fin_customer_bank_account_id
632: ra_customer_trx.customer_bank_account_id%type;
633: l_new_customer_trx_line_id
634: ra_customer_trx_lines.customer_trx_line_id%type;
635: l_ctt_bs_deflt_ctrx_type_id
636: ra_cust_trx_types.cust_trx_type_id%type;
637: l_allow_overapplication_flag
638: ra_cust_trx_types.allow_overapplication_flag%type;

Line 1812: from ra_customer_trx_lines

1808: if l_dept_no_return_status = FND_API.G_RET_STS_SUCCESS THEN
1809: begin
1810: select sum(EXTENDED_AMOUNT)
1811: into l_amount
1812: from ra_customer_trx_lines
1813: where customer_trx_id = l_customer_trx_id;
1814: end;
1815: end if;
1816:

Line 1821: from ra_customer_trx_lines

1817: if l_dept_no_return_status = FND_API.G_RET_STS_SUCCESS THEN
1818: begin
1819: select customer_trx_line_id
1820: into l_customer_trx_line_id
1821: from ra_customer_trx_lines
1822: where customer_trx_id = l_customer_trx_id; --only line per deposit
1823: exception when others then raise;
1824: end;
1825: end if;