APPS.PA_CI_SUPPLIER_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 96: budget_version_id in (select fin_plan_version_id from pa_proj_fp_options where project_id = proj_id and fin_plan_preference_code = 'COST_ONLY');

92:
93: cursor get_budget_cost_version_id(proj_id number) is
94: SELECT budget_version_id FROM pa_budget_versions
95: WHERE ci_id = p_ci_id and
96: budget_version_id in (select fin_plan_version_id from pa_proj_fp_options where project_id = proj_id and fin_plan_preference_code = 'COST_ONLY');
97:
98: cursor get_budget_rev_version_id(proj_id number) is
99: SELECT budget_version_id FROM pa_budget_versions
100: WHERE ci_id = p_ci_id and

Line 101: budget_version_id in (select fin_plan_version_id from pa_proj_fp_options where project_id = proj_id and fin_plan_preference_code = 'REVENUE_ONLY');

97:
98: cursor get_budget_rev_version_id(proj_id number) is
99: SELECT budget_version_id FROM pa_budget_versions
100: WHERE ci_id = p_ci_id and
101: budget_version_id in (select fin_plan_version_id from pa_proj_fp_options where project_id = proj_id and fin_plan_preference_code = 'REVENUE_ONLY');
102:
103: cursor get_project_id is
104: select project_id
105: from pa_control_items

Line 165: FROM pa_proj_fp_options ppfo,

161: ppfo.RES_CLASS_RAW_COST_SCH_ID,
162: ppfo.COST_RES_CLASS_RATE_SCH_ID,
163: ppfo.RES_CLASS_BILL_RATE_SCH_ID,
164: ppfo.REV_RES_CLASS_RATE_SCH_ID
165: FROM pa_proj_fp_options ppfo,
166: pa_control_items pci
167: WHERE pci.ci_id = p_ci_id and
168: pci.project_id = ppfo.project_id and
169: NVL(ppfo.Approved_Cost_Plan_Type_Flag ,'N') = 'Y' and

Line 1038: FROM pa_proj_fp_options ppfo,

1034: ppfo.RES_CLASS_RAW_COST_SCH_ID,
1035: ppfo.COST_RES_CLASS_RATE_SCH_ID,
1036: ppfo.RES_CLASS_BILL_RATE_SCH_ID,
1037: ppfo.REV_RES_CLASS_RATE_SCH_ID
1038: FROM pa_proj_fp_options ppfo,
1039: pa_control_items pci
1040: WHERE pci.ci_id = p_ci_id and
1041: pci.project_id = ppfo.project_id and
1042: NVL(ppfo.Approved_Cost_Plan_Type_Flag ,'N') = 'Y' and