DBA Data[Home] [Help]

APPS.PO_SIGNATURE_PVT dependencies on PO_LOOKUP_CODES

Line 613: FROM Po_Lookup_Codes

609:
610: BEGIN
611: SELECT displayed_field
612: INTO l_response_code
613: FROM Po_Lookup_Codes
614: WHERE Lookup_Type = 'ERECORD_RESPONSE'
615: AND Lookup_Code = l_response;
616: EXCEPTION
617: WHEN NO_DATA_FOUND THEN

Line 624: FROM Po_Lookup_Codes

620:
621: BEGIN
622: SELECT displayed_field
623: INTO l_reason_code
624: FROM Po_Lookup_Codes
625: WHERE Lookup_Type = 'ERECORD_REASON'
626: AND Lookup_Code = 'ERES_REASON';
627: EXCEPTION
628: WHEN NO_DATA_FOUND THEN

Line 635: FROM Po_Lookup_Codes

631:
632: BEGIN
633: SELECT displayed_field
634: INTO l_signer_type
635: FROM Po_Lookup_Codes
636: WHERE Lookup_Type = 'ERECORD_SIGNER_TYPE'
637: AND Lookup_Code = Decode(l_signer,'SUPPLIER','SUPPLIER','BUYER','CUSTOMER');
638: EXCEPTION
639: WHEN NO_DATA_FOUND THEN

Line 930: FROM Po_Lookup_Codes

926:
927: BEGIN
928: SELECT displayed_field
929: INTO l_response_code
930: FROM Po_Lookup_Codes
931: WHERE Lookup_Type = 'ERECORD_RESPONSE'
932: AND Lookup_Code = l_response;
933: EXCEPTION
934: WHEN NO_DATA_FOUND THEN