APPS.PON_OPEN_INTERFACE_PVT dependencies on PO_PRINT_FORM_FORMATS

Line 5738: AND lookup_code IN (SELECT DOCUMENT_FORMAT FROM PO_PRINT_FORM_FORMATS WHERE DOCUMENT_TYPE = 'PO_SOL_STD_FORM'

5734: WHERE LOOKUP_TYPE = 'PO_CLM_DOC_FORMAT'
5735: AND LANGUAGE = USERENV('LANG')
5736: AND ENABLED_FLAG = 'Y'
5737: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1) AND NVL(END_DATE_ACTIVE, SYSDATE + 1)
5738: AND lookup_code IN (SELECT DOCUMENT_FORMAT FROM PO_PRINT_FORM_FORMATS WHERE DOCUMENT_TYPE = 'PO_SOL_STD_FORM'
5739: and STANDARD_FORM = neg_header_record_data.STANDARD_FORM
5740: AND SYSDATE < Nvl(inactive_date,SYSDATE + 1))))
5741: THEN INTO PON_INTERFACE_ERRORS
5742: (

Line 5900: FROM PO_PRINT_FORM_FORMATS

5896: AND SYSDATE BETWEEN
5897: NVL(START_DATE_ACTIVE, SYSDATE - 1)
5898: AND NVL(END_DATE_ACTIVE, SYSDATE + 1)
5899: AND LOOKUP_CODE IN(SELECT STANDARD_FORM
5900: FROM PO_PRINT_FORM_FORMATS
5901: WHERE DOCUMENT_TYPE = 'PO_SOL_STD_FORM')
5902: ))
5903: THEN INTO PON_INTERFACE_ERRORS
5904: (

Line 6907: FROM PO_PRINT_FORM_FORMATS

6903: BEGIN
6904: IF ( neg_header_record_data.standard_form IS NULL AND p_is_amendment <> 'Y') THEN
6905: SELECT STANDARD_FORM,DOCUMENT_FORMAT
6906: INTO neg_header_record_data.standard_form,neg_header_record_data.document_format
6907: FROM PO_PRINT_FORM_FORMATS
6908: WHERE FORM_SOURCE='PON'
6909: AND DEFAULT_FLAG='Y'
6910: AND DOCUMENT_TYPE='PO_SOL_STD_FORM'
6911: AND SYSDATE < NVL(INACTIVE_DATE,SYSDATE + 1);