APPS.PO_CLM_INTG_GRP dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 628: FROM po_req_distributions_all d

624: IF p_doc_type = 'REQUISITION' THEN
625: IF p_distribution_id IS NOT NULL THEN
626: SELECT NVL(d.funded_value,0)
627: INTO l_funded
628: FROM po_req_distributions_all d
629: WHERE d.distribution_id = p_distribution_id;
630:
631: ELSE -- Distribution Id is null
632: IF p_line_id IS NOT NULL THEN

Line 635: FROM po_req_distributions_all d

631: ELSE -- Distribution Id is null
632: IF p_line_id IS NOT NULL THEN
633: SELECT SUM(NVL(d.funded_value,0))
634: INTO l_funded
635: FROM po_req_distributions_all d
636: WHERE d.requisition_line_id = p_line_id;
637:
638: ELSE -- Line Id is Null
639: SELECT SUM(NVL(d.funded_value,0))

Line 641: FROM po_req_distributions_all d,

637:
638: ELSE -- Line Id is Null
639: SELECT SUM(NVL(d.funded_value,0))
640: INTO l_funded
641: FROM po_req_distributions_all d,
642: po_requisition_lines_all l
643: WHERE d.requisition_line_id = l.requisition_line_id
644: AND l.requisition_header_id = p_header_id;
645: