DBA Data[Home] [Help]

APPS.IGW_REPORT_PROCESSING dependencies on IGW_BUDGET_CATEGORY_V

Line 414: from igw_budget_category_v pbcv

410: for rec_no_of_periods in c_no_of_periods
411: LOOP
412: select sum(base_amt)
413: into l_base_amount
414: from igw_budget_category_v pbcv
415: , igw_budget_details_cal_amts pbdc
416: , igw_rate_classes prc
417: where pbcv.line_item_id = pbdc.line_item_id
418: and pbdc.rate_class_id = prc.rate_class_id

Line 628: from igw_budget_category_v

624: , budget_period_id
625: into l_period_direct_cost_amt
626: , l_period_eb_amt
627: , l_budget_period_id
628: from igw_budget_category_v
629: where budget_category_code = rec_lowest_category.budget_category_code
630: and proposal_id = p_proposal_id
631: and version_id = l_version_id
632: and budget_period_id = rec_budget_period.budget_period_id

Line 715: from igw_budget_category_v

711: , budget_period_id
712: into l_period_direct_cost_amt
713: , l_period_eb_amt
714: , l_budget_period_id
715: from igw_budget_category_v
716: where budget_category_code = rec_parent_category.proposal_budget_category_code
717: and proposal_id = p_proposal_id
718: and version_id = l_version_id
719: and budget_period_id = rec_budget_period.budget_period_id

Line 860: from igw_budget_category_v

856: , budget_period_id
857: into l_period_direct_cost_amt
858: , l_period_eb_amt
859: , l_budget_period_id
860: from igw_budget_category_v
861: where budget_category_code NOT IN
862: (
863: select budget_category_code
864: from igw_report_budget_seed