DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on PO_LOOKUP_CODES

Line 3107: WHERE EXISTS ( SELECT 1 FROM po_lookup_codes

3103: THEN
3104: BEGIN
3105: SELECT 'Y' INTO is_valid_awd_type
3106: FROM dual
3107: WHERE EXISTS ( SELECT 1 FROM po_lookup_codes
3108: WHERE lookup_type IN ('PO_CLM_AWD_TYPE_SPO',
3109: 'PO_CLM_AWD_TYPE_ORD_OFF_IDV'
3110: )
3111: AND lookup_code = p_clm_award_type_tbl(i)

Line 3129: WHERE EXISTS ( SELECT 1 FROM po_lookup_codes

3125: THEN
3126: BEGIN
3127: SELECT 'Y' INTO is_valid_awd_type
3128: FROM dual
3129: WHERE EXISTS ( SELECT 1 FROM po_lookup_codes
3130: WHERE lookup_type = Decode(p_type_lookup_code_tbl(i),
3131: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,'PO_CLM_AWD_TYPE_BPA',
3132: PO_PDOI_CONSTANTS.g_DOC_TYPE_CONTRACT,'PO_CLM_AWD_TYPE_CPA')
3133: AND lookup_code = p_clm_award_type_tbl(i)