DBA Data[Home] [Help]

APPS.PO_AME_WF_PVT dependencies on PO_LOOKUP_CODES

Line 5403: FROM po_lookup_codes

5399:
5400: BEGIN
5401: SELECT displayed_field
5402: INTO l_approver_category
5403: FROM po_lookup_codes
5404: WHERE lookup_type = 'PO_APPROVER_TYPE'
5405: AND lookup_code = l_approver_category;
5406: EXCEPTION
5407: WHEN no_data_found THEN

Line 5668: FROM Po_Lookup_Codes

5664:
5665: BEGIN
5666: SELECT displayed_field
5667: INTO l_response_code
5668: FROM Po_Lookup_Codes
5669: WHERE Lookup_Type = 'ERECORD_RESPONSE'
5670: AND Lookup_Code = l_esigner_response;
5671: EXCEPTION
5672: WHEN NO_DATA_FOUND THEN

Line 5679: FROM Po_Lookup_Codes

5675:
5676: BEGIN
5677: SELECT displayed_field
5678: INTO l_reason_code
5679: FROM Po_Lookup_Codes
5680: WHERE Lookup_Type = 'ERECORD_REASON'
5681: AND Lookup_Code = 'ERES_REASON';
5682: EXCEPTION
5683: WHEN NO_DATA_FOUND THEN

Line 5690: FROM Po_Lookup_Codes

5686:
5687: BEGIN
5688: SELECT displayed_field
5689: INTO l_signer_type
5690: FROM Po_Lookup_Codes
5691: WHERE Lookup_Type = 'ERECORD_SIGNER_TYPE'
5692: AND Lookup_Code = Decode(l_signer,'BUYER','CUSTOMER');
5693: EXCEPTION
5694: WHEN NO_DATA_FOUND THEN