APPS.PN_INDEX_LEASE_COMMON_PKG dependencies on RA_CUST_TRX_TYPES

Line 565: -- 28-NOV-05 pikhar o Replaced ra_cust_trx_types with _ALL table.

561:
562: --------------------------------------------------------------------------------
563: -- PROCEDURE : GET_AR_TRX_TYPE
564: -- HISTORY
565: -- 28-NOV-05 pikhar o Replaced ra_cust_trx_types with _ALL table.
566: -- REDUNDANT FUNCTION - DO NOT USE!!
567: --------------------------------------------------------------------------------
568:
569: FUNCTION get_ar_trx_type (

Line 576: FROM ra_cust_trx_types

572: l_name VARCHAR2 (20);
573: BEGIN
574: SELECT name
575: INTO l_name
576: FROM ra_cust_trx_types
577: WHERE cust_trx_type_id = p_cust_trx_type_id;
578: RETURN l_name;
579: EXCEPTION
580: WHEN OTHERS

Line 1495: -- 28-NOV-05 pikhar o replaced ra_cust_trx_types with _ALL table.

1491: -- HISTORY :
1492: -- 24-Jun-05 piagrawa o Created
1493: -- IMPORTANT - Use this function once MOAC is enabled. All form libraries
1494: -- must call this.
1495: -- 28-NOV-05 pikhar o replaced ra_cust_trx_types with _ALL table.
1496: +============================================================================*/
1497:
1498: FUNCTION get_ar_trx_type ( p_cust_trx_type_id NUMBER
1499: ,p_org_id IN NUMBER) RETURN VARCHAR2 IS

Line 1504: FROM ra_cust_trx_types_all

1500: l_name VARCHAR2 (20);
1501: BEGIN
1502: SELECT name
1503: INTO l_name
1504: FROM ra_cust_trx_types_all
1505: WHERE cust_trx_type_id = p_cust_trx_type_id
1506: AND org_id = p_org_id;
1507:
1508: RETURN l_name;