DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on PO_PDOI_PARAMS

Line 2643: AND document_type = Decode (PO_PDOI_PARAMS.g_request.document_type,

2639: FROM dual
2640: WHERE p_clm_standard_form_tbl(i) IN ( SELECT DISTINCT standard_form
2641: FROM PO_PRINT_FORM_FORMATS
2642: WHERE style_id = p_style_id_tbl(i)
2643: AND document_type = Decode (PO_PDOI_PARAMS.g_request.document_type,
2644: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,'PO_AWARD_STD_FORM')
2645: AND inactive_date IS NULL
2646: );
2647: EXCEPTION

Line 2723: AND document_type = Decode (PO_PDOI_PARAMS.g_request.document_type,

2719: WHERE p_clm_document_format_tbl(i) IN ( SELECT document_format
2720: FROM PO_PRINT_FORM_FORMATS
2721: WHERE style_id = p_style_id_tbl(i)
2722: AND standard_form = p_clm_standard_form_tbl(i)
2723: AND document_type = Decode (PO_PDOI_PARAMS.g_request.document_type,
2724: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,'PO_AWARD_STD_FORM')
2725: AND inactive_date IS NULL
2726: );
2727: EXCEPTION