APPS.PA_CI_SUPPLIER_PKG dependencies on PA_BUDGET_VERSIONS

Line 90: from pa_budget_versions

86: where ci_transaction_id = ci_trans_id;
87:
88: cursor get_budget_version_id is
89: select budget_version_id
90: from pa_budget_versions
91: where ci_id = p_ci_id;
92:
93: cursor get_budget_cost_version_id(proj_id number) is
94: SELECT budget_version_id FROM pa_budget_versions

Line 94: SELECT budget_version_id FROM pa_budget_versions

90: from pa_budget_versions
91: where ci_id = p_ci_id;
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

Line 99: 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
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

Line 1004: from pa_budget_versions

1000: FOR UPDATE OF ci_transaction_id NOWAIT;
1001:
1002: cursor get_budget_version_id is
1003: select budget_version_id
1004: from pa_budget_versions
1005: where ci_id = p_ci_id;
1006:
1007: cursor get_project_id is
1008: select project_id

Line 1431: from pa_budget_versions

1427: where CI_TRANSACTION_ID = p_ci_transaction_id;
1428:
1429: cursor get_budget_version_id(p_ci_id number) is
1430: select budget_version_id
1431: from pa_budget_versions
1432: where ci_id = p_ci_id;
1433:
1434: cursor get_assignment_details(p_bvId number, p_task_id number, p_res_id number) is
1435: select pra.RESOURCE_ASSIGNMENT_ID, ppe.ELEMENT_NUMBER, ppe.NAME