APPS.PNP_UTIL_FUNC dependencies on RA_CUST_TRX_TYPES

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

5929: -- RETURNS : Transaction Type
5930: -- REFERENCE :
5931: -- HISTORY :
5932: -- 23-MAY-01 Mrinal Misra o Created
5933: -- 15-JUN-05 piagrawa o Bug 4307795 - Replaced ra_cust_trx_types
5934: -- with _ALL table.
5935: -- 24-Jun-05 Kiran o reverted the last change
5936: -- IMPORTANT - make not more changes to this function. This will be called
5937: -- pre MOAC / pre R12

Line 5941: l_trx_type ra_cust_trx_types.name%TYPE;

5937: -- pre MOAC / pre R12
5938: +============================================================================*/
5939: FUNCTION Get_Ar_Trx_type (p_trx_id IN NUMBER) RETURN VARCHAR2 IS
5940:
5941: l_trx_type ra_cust_trx_types.name%TYPE;
5942:
5943:
5944: BEGIN
5945:

Line 5948: FROM ra_cust_trx_types

5944: BEGIN
5945:
5946: SELECT name
5947: INTO l_trx_type
5948: FROM ra_cust_trx_types
5949: WHERE cust_trx_type_id = p_trx_id;
5950:
5951: RETURN(l_trx_type);
5952:

Line 8827: l_trx_type ra_cust_trx_types.name%TYPE;

8823: +============================================================================*/
8824: FUNCTION Get_Ar_Trx_type( p_trx_id IN NUMBER
8825: ,p_org_id IN NUMBER) RETURN VARCHAR2 IS
8826:
8827: l_trx_type ra_cust_trx_types.name%TYPE;
8828:
8829: BEGIN
8830:
8831: SELECT name

Line 8833: FROM ra_cust_trx_types_all

8829: BEGIN
8830:
8831: SELECT name
8832: INTO l_trx_type
8833: FROM ra_cust_trx_types_all
8834: WHERE cust_trx_type_id = p_trx_id
8835: AND org_id = p_org_id;
8836:
8837: RETURN(l_trx_type);