APPS.IGW_REPORT_PROCESSING dependencies on IGW_REPORT_BUDGET_SEED

Line 26: from igw_report_budget_seed

22: x_category VARCHAR2(80);
23: Begin
24: select distinct proposal_budget_category
25: into x_category
26: from igw_report_budget_seed
27: where proposal_form_number = p_proposal_form_number
28: and proposal_budget_category_code = p_category_code;
29:
30: RETURN x_category;

Line 120: from igw_report_budget_seed

116: cursor c_budget_category is
117: select distinct proposal_budget_category
118: , budget_category_code
119: , details_required_flag
120: from igw_report_budget_seed
121: where proposal_form_number = p_proposal_form_number
122: and budget_category_code NOT IN ('84','SB');
123:
124: cursor c_itemized_budget is

Line 554: from igw_report_budget_seed irs

550:
551:
552: cursor c_lowest_category is
553: select irs.budget_category_code
554: from igw_report_budget_seed irs
555: where irs.proposal_form_number = p_proposal_form_number
556: and irs.budget_category_code not in
557: (select distinct IR.proposal_budget_category_code
558: from igw_report_budget_seed IR

Line 558: from igw_report_budget_seed IR

554: from igw_report_budget_seed irs
555: where irs.proposal_form_number = p_proposal_form_number
556: and irs.budget_category_code not in
557: (select distinct IR.proposal_budget_category_code
558: from igw_report_budget_seed IR
559: where IR.proposal_form_number = p_proposal_form_number);
560:
561: cursor c_parent_category is
562: select distinct proposal_budget_category_code

Line 563: from igw_report_budget_seed

559: where IR.proposal_form_number = p_proposal_form_number);
560:
561: cursor c_parent_category is
562: select distinct proposal_budget_category_code
563: from igw_report_budget_seed
564: where proposal_form_number = p_proposal_form_number
565: and budget_category_code IN (
566: select proposal_budget_category_code
567: from igw_report_budget

Line 643: from igw_report_budget_seed

639: begin
640: l_budget_category := null;
641: select proposal_budget_category
642: into l_budget_category
643: from igw_report_budget_seed
644: where proposal_form_number = p_proposal_form_number
645: and budget_category_code = rec_lowest_category.budget_category_code;
646: exception
647: when no_data_found then

Line 680: --,igw_report_budget_seed_s.nextval

676: ,rec_lowest_category.budget_category_code
677: ,l_period_direct_cost_amt
678: ,l_period_eb_amt
679: ,p_proposal_form_number
680: --,igw_report_budget_seed_s.nextval
681: ,'Y');
682:
683: <>
684: l_period_direct_cost_amt := null;

Line 700: from igw_report_budget_seed

696: l_parent_exists := null;
697: begin
698: select '1'
699: into l_parent_exists
700: from igw_report_budget_seed
701: where budget_category_code = rec_parent_category.proposal_budget_category_code
702: and rownum < 2;
703: exception
704: when no_data_found then null;

Line 737: from igw_report_budget_seed

733: and budget_period_id = rec_budget_period.budget_period_id
734: and proposal_form_number = p_proposal_form_number
735: and proposal_budget_category_code IN (
736: select budget_category_code
737: from igw_report_budget_seed
738: where proposal_form_number = p_proposal_form_number
739: and proposal_budget_category_code = rec_parent_category.proposal_budget_category_code)
740: group by proposal_id, version_id, budget_period_id;
741:

Line 758: from igw_report_budget_seed

754: begin
755: l_budget_category := null;
756: select proposal_budget_category
757: into l_budget_category
758: from igw_report_budget_seed
759: where proposal_form_number = p_proposal_form_number
760: and budget_category_code = rec_parent_category.proposal_budget_category_code;
761: exception
762: when no_data_found then

Line 821: from igw_report_budget_seed

817: where proposal_form_number = p_proposal_form_number
818: and proposal_id = p_proposal_id
819: and proposal_budget_category_code IN (
820: select budget_category_code
821: from igw_report_budget_seed
822: where proposal_form_number = p_proposal_form_number
823: and proposal_budget_category_code = rec_parent_category.proposal_budget_category_code);
824:
825: if l_found = 1 then

Line 864: from igw_report_budget_seed

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
865: where proposal_form_number = p_proposal_form_number)
866: and proposal_id = p_proposal_id
867: and version_id = l_version_id
868: and budget_period_id = rec_budget_period.budget_period_id

Line 923: from igw_report_budget_seed

919: cursor c_budget_category is
920: select proposal_budget_category
921: , budget_category_code
922: , details_required_flag
923: from igw_report_budget_seed
924: where proposal_form_number = p_proposal_form_number
925: and details_required_flag = 'Y';
926:
927: cursor c_itemized_budget is