DBA Data[Home] [Help]

APPS.ARP_TRX_DEFAULTS_3 dependencies on RA_CUST_TRX_TYPES

Line 1514: p_class IN ra_cust_trx_types.type%type,

1510: p_type_term_name IN ra_terms.name%type,
1511: p_customer_id IN hz_cust_accounts.cust_account_id%type,
1512: p_site_use_id IN hz_cust_site_uses.site_use_id%type,
1513: p_trx_date IN ra_customer_trx.trx_date%type,
1514: p_class IN ra_cust_trx_types.type%type,
1515: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1516: p_default_term_id OUT NOCOPY ra_terms.term_id%type,
1517: p_default_term_name OUT NOCOPY ra_terms.name%type,
1518: p_number_of_due_dates OUT NOCOPY number,

Line 1515: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,

1511: p_customer_id IN hz_cust_accounts.cust_account_id%type,
1512: p_site_use_id IN hz_cust_site_uses.site_use_id%type,
1513: p_trx_date IN ra_customer_trx.trx_date%type,
1514: p_class IN ra_cust_trx_types.type%type,
1515: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1516: p_default_term_id OUT NOCOPY ra_terms.term_id%type,
1517: p_default_term_name OUT NOCOPY ra_terms.name%type,
1518: p_number_of_due_dates OUT NOCOPY number,
1519: p_term_due_date OUT NOCOPY

Line 1559: from ra_cust_trx_types

1555: -- R12:BFB
1556:
1557: select org_id
1558: into l_org_id
1559: from ra_cust_trx_types
1560: where cust_trx_type_id = p_cust_trx_type_id;
1561:
1562: l_cust_term_name := NULL;
1563: l_number_of_due_dates := NULL;

Line 1723: ra_cust_trx_types ctt

1719: rat.term_id
1720: INTO l_cust_term_name,
1721: l_cust_term_id
1722: FROM ra_terms rat,
1723: ra_cust_trx_types ctt
1724: WHERE ctt.cust_trx_type_id=p_cust_trx_type_id
1725: AND ctt.default_term=rat.term_id(+);
1726:
1727: IF (l_cust_term_id is NOT NULL)