APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_BUDGET_LINES

Line 462: pa_budget_lines

458: and pbv.period_profile_id = pp.period_profile_id;
459: Ends commented for 7514054 and added below code
460: */
461: select min(start_date) into pp_plan_start_date from
462: pa_budget_lines
463: where budget_version_id = p_orgfcst_version_id;
464:
465: select decode(nvl(cost_time_phased_code,
466: nvl(revenue_time_phased_code, all_time_phased_code)), 'G', 'GL', 'P', 'PA', 'N')

Line 537: from pa_budget_lines

533: -- Bug 8463770
534: /*
535: select min(start_date), max(end_date)
536: into ll_plan_start_date, ll_plan_end_date
537: from pa_budget_lines
538: where resource_assignment_id in (select
539: resource_assignment_id from
540: pa_budget_versions where budget_version_id = p_orgfcst_version_id);
541: */

Line 545: from pa_budget_lines

541: */
542:
543: select min(start_date), max(end_date)
544: into ll_plan_start_date, ll_plan_end_date
545: from pa_budget_lines
546: where budget_version_id = p_orgfcst_version_id;
547: -- Bug 8463770
548:
549: /* Ends- Added for bug 7456425 */

Line 1833: pa_budget_lines

1829: and pp.period_profile_id = pbv.period_profile_id;
1830: Ends commented for 7514054 and added below code
1831: */
1832: select min(start_date) into pp_plan_start_date from
1833: pa_budget_lines
1834: where budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID;
1835:
1836: select decode(nvl(cost_time_phased_code,
1837: nvl(revenue_time_phased_code, all_time_phased_code)), 'G', 'GL', 'P', 'PA', 'N')

Line 3820: exists (select 1 from pa_budget_lines bl

3816: ra.unit_of_measure
3817: from pa_resource_assignments ra
3818: where ra.budget_version_id = p_cost_budget_version_id and
3819: ((ra.resource_assignment_type = 'USER_ENTERED' and
3820: exists (select 1 from pa_budget_lines bl
3821: where bl.budget_version_id = ra.budget_version_id and
3822: bl.resource_assignment_id = ra.resource_assignment_id)) or
3823: ra.resource_assignment_type = 'ROLLED_UP');
3824:

Line 3869: exists (select 1 from pa_budget_lines bl

3865: ra.unit_of_measure
3866: from pa_resource_assignments ra
3867: where ra.budget_version_id = p_rev_budget_version_id and
3868: ((ra.resource_assignment_type = 'USER_ENTERED' and
3869: exists (select 1 from pa_budget_lines bl
3870: where bl.budget_version_id = ra.budget_version_id and
3871: bl.resource_assignment_id = ra.resource_assignment_id)) or
3872: ra.resource_assignment_type = 'ROLLED_UP');
3873:

Line 6954: exists (select 1 from pa_budget_lines bl

6950: where ra.budget_version_id = p_budget_version_id and
6951: ra.budget_version_id = po.fin_plan_version_id and
6952: po.fin_plan_option_level_code='PLAN_VERSION' and
6953: ((ra.resource_assignment_type = 'USER_ENTERED' and
6954: exists (select 1 from pa_budget_lines bl
6955: where bl.budget_version_id = ra.budget_version_id and
6956: bl.resource_assignment_id = ra.resource_assignment_id)) or
6957: ra.resource_assignment_type = 'ROLLED_UP');
6958:

Line 8370: exists (select 1 from pa_budget_lines bl

8366: where ra.budget_version_id = p_budget_version_id and
8367: ra.budget_version_id = po.fin_plan_version_id and
8368: po.fin_plan_option_level_code='PLAN_VERSION' and
8369: ((ra.resource_assignment_type = 'USER_ENTERED' and
8370: exists (select 1 from pa_budget_lines bl
8371: where bl.budget_version_id = ra.budget_version_id and
8372: bl.resource_assignment_id = ra.resource_assignment_id)) or
8373: ra.resource_assignment_type = 'ROLLED_UP');
8374:

Line 8428: exists (select 1 from pa_budget_lines bl

8424: where ra.budget_version_id = p_budget_version_id and
8425: ra.budget_version_id = po.fin_plan_version_id and
8426: po.fin_plan_option_level_code='PLAN_VERSION' and
8427: ((ra.resource_assignment_type = 'USER_ENTERED' and
8428: exists (select 1 from pa_budget_lines bl
8429: where bl.budget_version_id = ra.budget_version_id and
8430: bl.resource_assignment_id = ra.resource_assignment_id)) or
8431: ra.resource_assignment_type = 'ROLLED_UP');
8432: