APPS.AP_WEB_AME_PKG dependencies on AP_EXP_REPORT_DISTS_ALL

Line 566: from ap_exp_report_dists_all

562: -- and report_line_id = p_item_id;
563: elsif (p_item_class = C_PROJECT) then
564: select nvl(sum(amount),0)
565: into p_amount
566: from ap_exp_report_dists_all
567: where report_header_id = p_report_header_id
568: and project_id = p_item_id;
569: elsif (p_item_class = C_AWARD) then
570: select nvl(sum(amount),0)

Line 572: from ap_exp_report_dists_all

568: and project_id = p_item_id;
569: elsif (p_item_class = C_AWARD) then
570: select nvl(sum(amount),0)
571: into p_amount
572: from ap_exp_report_dists_all
573: where report_header_id = p_report_header_id
574: and award_id = p_item_id;
575: elsif (p_item_class = C_COST_CENTER) then
576: select nvl(sum(amount),0)

Line 578: from ap_exp_report_dists_all

574: and award_id = p_item_id;
575: elsif (p_item_class = C_COST_CENTER) then
576: select nvl(sum(amount),0)
577: into p_amount
578: from ap_exp_report_dists_all
579: where report_header_id = p_report_header_id
580: and cost_center = p_item_id;
581: end if;
582:

Line 891: from ap_exp_report_dists_all xd,

887: */
888: if i.itemization_parent_id = -1 then
889: select nvl(sum(xd.amount),0)
890: into l_approver_amount
891: from ap_exp_report_dists_all xd,
892: oie_ame_notif_gt gt
893: where xd.report_header_id = p_report_header_id
894: and xd.report_line_id in (
895: select report_line_id

Line 913: from ap_exp_report_dists_all xd,

909: gt.item_class = C_AWARD) );
910: else
911: select nvl(sum(xd.amount),0)
912: into l_approver_amount
913: from ap_exp_report_dists_all xd,
914: oie_ame_notif_gt gt
915: where xd.report_header_id = p_report_header_id
916: and xd.report_line_id = i.report_line_id
917: and ( (xd.cost_center = gt.item_id