DBA Data[Home] [Help]

APPS.PA_INVOICE_XFER dependencies on PA_LOOKUPS

Line 1284: from pa_lookups

1280: AS
1281: cursor get_reason ( l_rej_code in varchar2)
1282: is
1283: select nvl(meaning ,l_rej_code)
1284: from pa_lookups
1285: where lookup_type = 'TRANSFER REJECTION CODE'
1286: and lookup_code = l_rej_code;
1287:
1288: i NUMBER;

Line 1431: FROM pa_lookups

1427: -- assign pa_imp values
1428:
1429: BEGIN
1430: SELECT description into p_error_message
1431: FROM pa_lookups
1432: WHERE lookup_type='AR TRANSACTION TYPE MISSING' AND
1433: lookup_code ='AR_TRX_TYPE_NOT_FOUND';
1434:
1435: EXCEPTION