DBA Data[Home] [Help]

APPS.PO_FED_FIELD_FUNCTIONS dependencies on PO_LOOKUP_CODES

Line 504: FROM po_lookup_codes

500: x_msg_data := 'SUCCESS';
501: ELSE
502: SELECT displayed_field
503: INTO l_AddTypeDispField
504: FROM po_lookup_codes
505: WHERE lookup_type like '%PR_UDA_ADDRESS_TYPES'
506: AND lookup_code = p_HiddenAddType
507: AND rownum =1 ;
508:

Line 596: FROM po_lookup_codes

592: ELSE
593:
594: SELECT displayed_field
595: INTO l_AddTypeDispField
596: FROM po_lookup_codes
597: WHERE lookup_type = 'PO_MOD_UDA_ADDRESS_TYPES'
598: AND lookup_code = p_HiddenAddType;
599:
600:

Line 1047: FROM PO_LOOKUP_CODES

1043:
1044:
1045: SELECT DESCRIPTION
1046: INTO x_cust_proj_text
1047: FROM PO_LOOKUP_CODES
1048: WHERE LOOKUP_TYPE = 'PO_CLM_CUSTOMER_PROJECT_CODE'
1049: AND LOOKUP_CODE = p_cust_proj_code;
1050:
1051: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1098: FROM PO_LOOKUP_CODES

1094:
1095: IF p_cust_proj_code IS NOT NULL THEN
1096: SELECT DESCRIPTION
1097: INTO x_cust_proj_text
1098: FROM PO_LOOKUP_CODES
1099: WHERE LOOKUP_TYPE = 'PO_CLM_CUSTOMER_PROJECT_CODE'
1100: AND LOOKUP_CODE = p_cust_proj_code;
1101: END IF;
1102:

Line 1176: FROM PO_LOOKUP_CODES

1172:
1173: IF p_cust_proj_code IS NOT NULL THEN
1174: SELECT DESCRIPTION
1175: INTO x_cust_proj_text
1176: FROM PO_LOOKUP_CODES
1177: WHERE LOOKUP_TYPE = 'PO_CLM_CUSTOMER_PROJECT_CODE'
1178: AND LOOKUP_CODE = p_cust_proj_code;
1179: END IF;
1180: