APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_BUDGET_LINES

Line 3691: exists (select 1 from pa_budget_lines bl

3687: ra.unit_of_measure
3688: from pa_resource_assignments ra
3689: where ra.budget_version_id = p_cost_budget_version_id and
3690: ((ra.resource_assignment_type = 'USER_ENTERED' and
3691: exists (select 1 from pa_budget_lines bl
3692: where bl.budget_version_id = ra.budget_version_id and
3693: bl.resource_assignment_id = ra.resource_assignment_id)) or
3694: ra.resource_assignment_type = 'ROLLED_UP');
3695:

Line 3740: exists (select 1 from pa_budget_lines bl

3736: ra.unit_of_measure
3737: from pa_resource_assignments ra
3738: where ra.budget_version_id = p_rev_budget_version_id and
3739: ((ra.resource_assignment_type = 'USER_ENTERED' and
3740: exists (select 1 from pa_budget_lines bl
3741: where bl.budget_version_id = ra.budget_version_id and
3742: bl.resource_assignment_id = ra.resource_assignment_id)) or
3743: ra.resource_assignment_type = 'ROLLED_UP');
3744:

Line 6344: exists (select 1 from pa_budget_lines bl

6340: where ra.budget_version_id = p_budget_version_id and
6341: ra.budget_version_id = po.fin_plan_version_id and
6342: po.fin_plan_option_level_code='PLAN_VERSION' and
6343: ((ra.resource_assignment_type = 'USER_ENTERED' and
6344: exists (select 1 from pa_budget_lines bl
6345: where bl.budget_version_id = ra.budget_version_id and
6346: bl.resource_assignment_id = ra.resource_assignment_id)) or
6347: ra.resource_assignment_type = 'ROLLED_UP');
6348:

Line 7401: exists (select 1 from pa_budget_lines bl

7397: where ra.budget_version_id = p_budget_version_id and
7398: ra.budget_version_id = po.fin_plan_version_id and
7399: po.fin_plan_option_level_code='PLAN_VERSION' and
7400: ((ra.resource_assignment_type = 'USER_ENTERED' and
7401: exists (select 1 from pa_budget_lines bl
7402: where bl.budget_version_id = ra.budget_version_id and
7403: bl.resource_assignment_id = ra.resource_assignment_id)) or
7404: ra.resource_assignment_type = 'ROLLED_UP');
7405:

Line 7459: exists (select 1 from pa_budget_lines bl

7455: where ra.budget_version_id = p_budget_version_id and
7456: ra.budget_version_id = po.fin_plan_version_id and
7457: po.fin_plan_option_level_code='PLAN_VERSION' and
7458: ((ra.resource_assignment_type = 'USER_ENTERED' and
7459: exists (select 1 from pa_budget_lines bl
7460: where bl.budget_version_id = ra.budget_version_id and
7461: bl.resource_assignment_id = ra.resource_assignment_id)) or
7462: ra.resource_assignment_type = 'ROLLED_UP');
7463: