DBA Data[Home] [Help]

APPS.PO_SIGNATURE_PVT dependencies on PO_LOOKUP_CODES

Line 741: FROM Po_Lookup_Codes

737:
738: BEGIN
739: SELECT displayed_field
740: INTO l_response_code
741: FROM Po_Lookup_Codes
742: WHERE Lookup_Type = 'ERECORD_RESPONSE'
743: AND Lookup_Code = l_response;
744: EXCEPTION
745: WHEN NO_DATA_FOUND THEN

Line 752: FROM Po_Lookup_Codes

748:
749: BEGIN
750: SELECT displayed_field
751: INTO l_reason_code
752: FROM Po_Lookup_Codes
753: WHERE Lookup_Type = 'ERECORD_REASON'
754: AND Lookup_Code = 'ERES_REASON';
755: EXCEPTION
756: WHEN NO_DATA_FOUND THEN

Line 763: FROM Po_Lookup_Codes

759:
760: BEGIN
761: SELECT displayed_field
762: INTO l_signer_type
763: FROM Po_Lookup_Codes
764: WHERE Lookup_Type = 'ERECORD_SIGNER_TYPE'
765: AND Lookup_Code = Decode(l_signer,'SUPPLIER','SUPPLIER','BUYER','CUSTOMER');
766: EXCEPTION
767: WHEN NO_DATA_FOUND THEN

Line 1179: FROM Po_Lookup_Codes

1175:
1176: BEGIN
1177: SELECT displayed_field
1178: INTO l_response_code
1179: FROM Po_Lookup_Codes
1180: WHERE Lookup_Type = 'ERECORD_RESPONSE'
1181: AND Lookup_Code = l_response;
1182: EXCEPTION
1183: WHEN NO_DATA_FOUND THEN