DBA Data[Home] [Help]

APPS.AR_DEPOSIT_LIB_PVT dependencies on RA_CUST_TRX_TYPES

Line 1698: FROM ra_cust_trx_types

1694:
1695: BEGIN
1696: SELECT cust_trx_type_id
1697: INTO x_cust_trx_type_id
1698: FROM ra_cust_trx_types
1699: where type = 'DEP' and
1700: nvl(p_deposit_date, trunc(sysdate)) between
1701: nvl(start_date(+), nvl(p_deposit_date, trunc(sysdate))) and
1702: nvl(end_date(+), nvl(p_deposit_date, trunc(sysdate))) and

Line 1729: FROM ra_cust_trx_types

1725: -- validate x_cust_trx_type_id
1726: BEGIN
1727: SELECT cust_trx_type_id
1728: INTO l_dummy
1729: FROM ra_cust_trx_types
1730: where type = 'DEP' and
1731: nvl(p_deposit_date, trunc(sysdate)) between
1732: nvl(start_date(+), nvl(p_deposit_date, trunc(sysdate))) and
1733: nvl(end_date(+), nvl(p_deposit_date, trunc(sysdate))) and