APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_PROJECTS_ALL

Line 59: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

55: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
56: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
57: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
58:
59: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
60:
61: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
62:
63: l_period_set_name gl_sets_of_books.period_set_name%TYPE;

Line 95: from pa_budget_versions a, pa_projects_all b

91: C_Get_res_info_rec C_Get_res_info%ROWTYPE;
92:
93: CURSOR C_Get_Budget_Version_Id(p_structure_version_id IN NUMBER, p_project_id IN NUMBER) is
94: select a.budget_version_id, b.project_currency_code
95: from pa_budget_versions a, pa_projects_all b
96: where a.project_structure_version_id = p_structure_version_id
97: and a.project_id = b.project_id
98: and a.project_id = p_project_id;
99:

Line 209: ,pa_projects_all ppa

205: 'REVENUE',ppfo.revenue_time_phased_code,
206: ppfo.all_time_phased_code) time_phase_code
207: FROM gl_sets_of_books gsb
208: ,pa_implementations_all pia
209: ,pa_projects_all ppa
210: ,pa_budget_versions pbv
211: ,pa_proj_fp_options ppfo
212: WHERE ppa.project_id = pbv.project_id
213: AND pbv.budget_version_id = ppfo.fin_plan_version_id

Line 1332: ,pa_projects_all ppa

1328: ppfo.all_time_phased_code) time_phase_code
1329: ,glp.start_date period_start_date,glp.end_date period_end_date
1330: FROM gl_sets_of_books gsb
1331: ,pa_implementations_all pia
1332: ,pa_projects_all ppa
1333: ,pa_budget_versions pbv
1334: ,pa_proj_fp_options ppfo
1335: ,gl_periods glp
1336: WHERE ppa.project_id = pbv.project_id

Line 1524: ( p_project_id IN PA_PROJECTS_ALL.project_id%TYPE

1520: * as the task level assignment with ta_display_flag = 'N' if
1521: * rlm is not passed into the API.
1522: **********************************************************************/
1523: PROCEDURE Derive_Task_Assignments
1524: ( p_project_id IN PA_PROJECTS_ALL.project_id%TYPE
1525: ,p_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE
1526: ,p_scheduled_start IN DATE
1527: ,p_scheduled_end IN DATE
1528: ,p_resource_class_code IN PA_RESOURCE_LIST_MEMBERS.resource_class_code%TYPE

Line 1597: FROM pa_projects_all

1593: and rownum = 1;
1594:
1595: CURSOR get_proj_cur_code IS
1596: SELECT project_currency_code
1597: FROM pa_projects_all
1598: where project_id = p_project_id;
1599:
1600: CURSOR check_none_resource_list(c_resource_list_id NUMBER) IS
1601: SELECT uncategorized_flag

Line 1850: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

1846:
1847:
1848: PROCEDURE Copy_Missing_Unplanned_Asgmts
1849: (
1850: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
1851: p_old_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1852: p_new_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1853: p_new_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
1854: x_msg_count OUT NOCOPY NUMBER,