APPS.PO_COMM_FPDSNG_PVT dependencies on DUAL

Line 337: FROM dual';

333: l_progress:='007';
334: l_idvidQuery:=' SELECT decode(PO_COMM_FPDSNG_PVT.getReleaseId(), null,
335: PO_COMM_FPDSNG_PVT.getDocumentId(),PO_COMM_FPDSNG_PVT.getReleaseId()) PIID,
336: PO_COMM_FPDSNG_PVT.getRevisionNum modNumber
337: FROM dual';
338:
339: l_progress:='008';
340: l_refidvidQuery := 'SELECT PO_COMM_FPDSNG_PVT.getDocumentId() PIID,
341: PO_COMM_FPDSNG_PVT.getRevisionNum modNumber

Line 342: from dual';

338:
339: l_progress:='008';
340: l_refidvidQuery := 'SELECT PO_COMM_FPDSNG_PVT.getDocumentId() PIID,
341: PO_COMM_FPDSNG_PVT.getRevisionNum modNumber
342: from dual';
343:
344: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
345: l_progress:='009';
346: l_ContractDatesQuery :=' SELECT poh.start_date effectiveDate,

Line 635: SELECT userenv('LANG') INTO l_language FROM dual;

631: END IF;
632:
633: --Get the Language
634: l_progress:='043';
635: SELECT userenv('LANG') INTO l_language FROM dual;
636:
637: --Get the PDF Name
638: l_progress:='044';
639: l_file_name := getFPDSNGFileName(l_doc_type, --p_document_type