APPS.PA_COST1 dependencies on PA_TASKS

Line 46: * if the given task is not exists in pa_tasks the derive the

42:
43: END print_msg ;
44:
45: /* This API checks whether the given task is a financial task
46: * if the given task is not exists in pa_tasks the derive the
47: * burden sch details from project level
48: */
49: FUNCTION is_workPlan_Task(p_project_id IN Number
50: ,p_task_id IN Number )

Line 60: from pa_tasks t

56: SELECT 'N'
57: INTO l_exists_flag
58: FROM dual
59: WHERE EXISTS (select null
60: from pa_tasks t
61: where t.task_id = p_task_id
62: and t.project_id = p_project_id);
63: End If;
64:

Line 112: FROM pa_tasks t

108: BEGIN
109: l_stage := 'Getting labor cost multiplier ';
110: SELECT lcm.multiplier
111: INTO l_cost_rate_multiplier
112: FROM pa_tasks t
113: ,pa_labor_cost_multipliers lcm
114: WHERE t.task_id = p_task_id
115: AND t.labor_cost_multiplier_name = lcm.labor_cost_multiplier_name
116: AND trunc(P_exp_item_date) BETWEEN LCM.start_date_active AND

Line 179: FROM pa_tasks t,

175: -- Select the Task level schedule override if not found
176: -- then select the Project level override
177: SELECT irs.ind_rate_sch_id
178: INTO x_burden_sch_id
179: FROM pa_tasks t,
180: pa_ind_rate_schedules irs
181: WHERE t.task_id = p_task_id
182: AND t.project_id = p_project_id
183: AND t.task_id = irs.task_id

Line 203: FROM pa_tasks t

199: -- check the task level schedule (not the override)
200: BEGIN
201: SELECT t.cost_ind_rate_sch_id
202: INTO x_burden_sch_id
203: FROM pa_tasks t
204: WHERE t.task_id = p_task_id
205: AND t.project_id = p_project_id;
206:
207: EXCEPTION

Line 1328: -- and not pa_tasks. Non-shared workplan tasks do not exist in pa_tasks.

1324:
1325: if p_task_id is not null then
1326: -- get the task number details
1327: -- bug 12557318: changed the cursor to get the task_number from pa_proj_elements
1328: -- and not pa_tasks. Non-shared workplan tasks do not exist in pa_tasks.
1329: begin
1330: select element_number
1331: into pa_pay_util.g_task_number
1332: from pa_proj_elements

Line 1344: from pa_tasks

1340: when no_data_found then
1341: begin
1342: select task_number
1343: into pa_pay_util.g_task_number
1344: from pa_tasks
1345: where task_id = p_task_id;
1346:
1347: l_stage := 'RBC: Task Number from fin tasks: ' || pa_pay_util.g_task_number;
1348: print_msg(l_debug_flag,l_stage);

Line 1361: from pa_work_types_vl a, pa_tasks b

1357: -- work plan tasks do not have work types associated to tasks.
1358: begin
1359: select name
1360: into pa_pay_util.g_work_type_name
1361: from pa_work_types_vl a, pa_tasks b
1362: where a.work_type_id = b.work_type_id
1363: and b.task_id = p_task_id;
1364:
1365: l_stage := 'RBC: Work Type name: ' || pa_pay_util.g_work_type_name;