DBA Data[Home] [Help]

APPS.AR_DEPOSIT_LIB_PVT dependencies on RA_CUST_TRX_TYPES

Line 1700: FROM ra_cust_trx_types

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

Line 1731: FROM ra_cust_trx_types

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