APPS.PNP_UTIL_FUNC dependencies on RA_CUST_TRX_TYPES

Line 5772: -- 15-JUN-05 piagrawa o Bug 4307795 - Replaced ra_cust_trx_types

5768: -- RETURNS : Transaction Type
5769: -- REFERENCE :
5770: -- HISTORY :
5771: -- 23-MAY-01 Mrinal Misra o Created
5772: -- 15-JUN-05 piagrawa o Bug 4307795 - Replaced ra_cust_trx_types
5773: -- with _ALL table.
5774: -- 24-Jun-05 Kiran o reverted the last change
5775: -- IMPORTANT - make not more changes to this function. This will be called
5776: -- pre MOAC / pre R12

Line 5780: l_trx_type ra_cust_trx_types.name%TYPE;

5776: -- pre MOAC / pre R12
5777: +============================================================================*/
5778: FUNCTION Get_Ar_Trx_type (p_trx_id IN NUMBER) RETURN VARCHAR2 IS
5779:
5780: l_trx_type ra_cust_trx_types.name%TYPE;
5781:
5782:
5783: BEGIN
5784:

Line 5787: FROM ra_cust_trx_types

5783: BEGIN
5784:
5785: SELECT name
5786: INTO l_trx_type
5787: FROM ra_cust_trx_types
5788: WHERE cust_trx_type_id = p_trx_id;
5789:
5790: RETURN(l_trx_type);
5791:

Line 8649: l_trx_type ra_cust_trx_types.name%TYPE;

8645: +============================================================================*/
8646: FUNCTION Get_Ar_Trx_type( p_trx_id IN NUMBER
8647: ,p_org_id IN NUMBER) RETURN VARCHAR2 IS
8648:
8649: l_trx_type ra_cust_trx_types.name%TYPE;
8650:
8651: BEGIN
8652:
8653: SELECT name

Line 8655: FROM ra_cust_trx_types_all

8651: BEGIN
8652:
8653: SELECT name
8654: INTO l_trx_type
8655: FROM ra_cust_trx_types_all
8656: WHERE cust_trx_type_id = p_trx_id
8657: AND org_id = p_org_id;
8658:
8659: RETURN(l_trx_type);