APPS.PO_VAL_HEADERS dependencies on PO_PRINT_FORM_FORMATS

Line 1233: FROM po_print_form_formats ppff

1229: WHERE PDSH.style_id = p_style_id_tbl(i)
1230: AND nvl(clm_flag, 'N') ='Y'
1231: AND NOT EXISTS (
1232: SELECT 1
1233: FROM po_print_form_formats ppff
1234: WHERE ppff.document_type = decode(nvl(p_draft_type_tbl(i), '*'),
1235: 'MOD', 'PO_MOD_STD_FORM', -- bug 10389450 start
1236: decode(p_type_lookup_code_tbl(i), c_STANDARD,
1237: decode(p_clm_award_type_tbl(i),

Line 2641: FROM PO_PRINT_FORM_FORMATS

2637: BEGIN
2638: SELECT 'Y' INTO l_valid_standard_form
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

Line 2720: FROM PO_PRINT_FORM_FORMATS

2716: BEGIN
2717: SELECT 'Y' INTO l_valid_document_format
2718: FROM dual
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')