DBA Data[Home] [Help]

APPS.PSA_BC_XLA_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1154: IF p_dist_link_type = 'PO_REQ_DISTRIBUTIONS_ALL' THEN

1150: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value = ' || to_char(l_r12_upgrade_date));
1151:
1152: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch CREATION_DATE of the Distribution '|| p_distribution_id);
1153:
1154: IF p_dist_link_type = 'PO_REQ_DISTRIBUTIONS_ALL' THEN
1155: SELECT min(creation_date) INTO l_dist_creation_date
1156: FROM po_req_distributions_all
1157: WHERE distribution_id = p_distribution_id;
1158: ELSIF p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' THEN

Line 1156: FROM po_req_distributions_all

1152: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch CREATION_DATE of the Distribution '|| p_distribution_id);
1153:
1154: IF p_dist_link_type = 'PO_REQ_DISTRIBUTIONS_ALL' THEN
1155: SELECT min(creation_date) INTO l_dist_creation_date
1156: FROM po_req_distributions_all
1157: WHERE distribution_id = p_distribution_id;
1158: ELSIF p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' THEN
1159: SELECT min(creation_date) INTO l_dist_creation_date
1160: FROM po_distributions_all