DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on PO_REQUISITION_HEADERS_ALL

Line 2689: FROM po_requisition_headers_all prh, FND_LOOKUP_VALUES FLV

2685:
2686: -- MIPR Changes
2687: CURSOR mipr_csr(p_doc_id NUMBER) IS
2688: SELECT flv.MEANING
2689: FROM po_requisition_headers_all prh, FND_LOOKUP_VALUES FLV
2690: WHERE prh.requisition_header_id = p_doc_id
2691: AND prh.clm_mipr_type = flv.LOOKUP_CODE
2692: AND NVL(prh.cancel_flag,'N') = 'N'
2693: AND FLV.LOOKUP_TYPE='MIPR_TYPE'

Line 3328: FROM po_requisition_headers_all prh, FND_LOOKUP_VALUES FLV, FND_LANGUAGES FL

3324:
3325: -- MIPR Changes
3326: CURSOR mipr_csr(p_doc_id NUMBER, p_language varchar2) IS
3327: SELECT flv.MEANING
3328: FROM po_requisition_headers_all prh, FND_LOOKUP_VALUES FLV, FND_LANGUAGES FL
3329: WHERE prh.requisition_header_id = p_doc_id
3330: AND prh.clm_mipr_type = flv.LOOKUP_CODE
3331: AND NVL(cancel_flag,'N') = 'N'
3332: AND FL.NLS_LANGUAGE = p_language