APPS.AP_WEB_EXPORT_ER dependencies on AP_EXP_REPORT_DISTS_ALL

Line 821: FROM ap_exp_report_dists_all

817: END IF;
818:
819: SELECT count(*)
820: INTO l_dist_count
821: FROM ap_exp_report_dists_all
822: WHERE report_header_id = p_report_header_id
823: AND amount IS NULL;
824:
825: IF g_debug_switch = 'Y' THEN

Line 847: select nvl(sum(amount),0) into l_dist_total from ap_exp_report_dists_all where report_header_id = p_report_header_id

843: and (itemization_parent_id is null or itemization_parent_id <> -1)
844: and web_parameter_id <> l_parameter_id;
845:
846: l_debug_info := 'Fetching Dist Total';
847: select nvl(sum(amount),0) into l_dist_total from ap_exp_report_dists_all where report_header_id = p_report_header_id
848: and (web_parameter_id is null or web_parameter_id <> l_parameter_id);
849:
850: l_debug_info := 'Header Total: ' || l_header_total || ', Line Total: ' || l_line_total || ', Dist Total: ' || l_dist_total;
851: IF g_debug_switch = 'Y' THEN