APPS.PA_FP_GEN_BILLING_AMOUNTS dependencies on PA_TASKS

Line 95: l_task_id pa_tasks.task_id%TYPE;

91: l_msg_index_out NUMBER;
92: l_pc_code pa_projects_all.project_currency_code%type;
93: l_pfc_code pa_projects_all.project_currency_code%type;
94: l_project_name pa_projects_all.name%TYPE;
95: l_task_id pa_tasks.task_id%TYPE;
96: l_task_name pa_proj_elements.name%TYPE;
97: l_resource_name pa_resource_list_members.alias%TYPE;
98: BEGIN
99: /* Setting initial values */

Line 134: FROM pa_tasks

130: IF l_task_id > 0 THEN
131: BEGIN
132: SELECT task_name
133: INTO l_task_name
134: FROM pa_tasks
135: WHERE task_id = l_task_id;
136: EXCEPTION
137: WHEN OTHERS THEN
138: l_task_name := null;

Line 2109: PA_TASKS TS

2105: l_txn_top_task_id_tab,
2106: l_txn_sub_task_id_tab
2107: FROM PA_RESOURCE_ASSIGNMENTS P,
2108: PA_RES_LIST_MAP_TMP4 T,
2109: PA_TASKS TS
2110: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
2111: AND TS.TASK_ID(+) = NVL(T.TXN_TASK_ID,0)
2112: AND NVL(P.TASK_ID,0) = NVL(TS.TOP_TASK_ID,0)
2113: AND P.PROJECT_ASSIGNMENT_ID = -1

Line 2238: PA_TASKS TS

2234: NVL(V.MAPPED_FIN_TASK_ID,0) mapped_fin_task_id
2235: FROM PA_RESOURCE_ASSIGNMENTS P,
2236: PA_RES_LIST_MAP_TMP4 T,
2237: PA_MAP_WP_TO_FIN_TASKS_V V,
2238: PA_TASKS TS
2239: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
2240: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
2241: AND t.txn_task_id = v.PROJ_ELEMENT_ID
2242: AND NVL(TS.top_TASK_ID,0) = NVL(p.task_id,0)