APPS.PSA_BC_XLA_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 764: ELSIF p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' THEN

760: IF p_dist_link_type = 'PO_REQ_DISTRIBUTIONS_ALL' THEN
761: SELECT min(creation_date) INTO l_dist_creation_date
762: FROM po_req_distributions_all
763: WHERE distribution_id = p_distribution_id;
764: ELSIF p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' THEN
765: SELECT min(creation_date) INTO l_dist_creation_date
766: FROM po_distributions_all
767: WHERE po_distribution_id = p_distribution_id;
768: ELSIF p_dist_link_type = 'AP_INV_DIST' THEN

Line 766: FROM po_distributions_all

762: FROM po_req_distributions_all
763: WHERE distribution_id = p_distribution_id;
764: ELSIF p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' THEN
765: SELECT min(creation_date) INTO l_dist_creation_date
766: FROM po_distributions_all
767: WHERE po_distribution_id = p_distribution_id;
768: ELSIF p_dist_link_type = 'AP_INV_DIST' THEN
769: SELECT min(creation_date) INTO l_dist_creation_date
770: FROM ap_invoice_distributions_all

Line 792: IF (p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' ) THEN

788: CLOSE c_check;
789:
790: IF l_check_variable ='1' THEN
791: -- Following IF added for Bug 7598349
792: IF (p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' ) THEN
793: OPEN c_po_upg_chk(p_application_id,
794: p_entity_code,
795: p_source_id_int_1,
796: l_r12_upgrade_date);

Line 806: END IF; -- p_dist_link_type = 'PO_DISTRIBUTIONS_ALL'

802: l_return_val := 'N';
803: END IF;
804: ELSE
805: l_return_val := 'N'; --this means data exists in sla and is a R12 entry
806: END IF; -- p_dist_link_type = 'PO_DISTRIBUTIONS_ALL'
807: ELSE
808: IF FV_INSTALL.ENABLED THEN
809: l_return_val := 'O'; --Make use of Upgrade tab in JLD form
810: ELSE