DBA Data[Home] [Help]

APPS.PSA_BC_XLA_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 760: IF p_dist_link_type = 'PO_REQ_DISTRIBUTIONS_ALL' THEN

756: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value = ' || to_char(l_r12_upgrade_date));
757:
758: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch CREATION_DATE of the Distribution '|| p_distribution_id);
759:
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

Line 762: FROM po_req_distributions_all

758: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch CREATION_DATE of the Distribution '|| p_distribution_id);
759:
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