APPS.PA_RATE_PVT_PKG dependencies on PA_TASKS

Line 166: l_labor_cost_mult_name pa_tasks.labor_cost_multiplier_name%TYPE;

162: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;
163: l_forecast_job_id pa_project_assignments.fcst_job_id%TYPE;
164: l_forecast_job_group_id pa_project_assignments.fcst_job_group_id%TYPE;
165:
166: l_labor_cost_mult_name pa_tasks.labor_cost_multiplier_name%TYPE;
167: l_project_type pa_project_types_all.project_type%TYPE;
168: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
169: l_project_org_id pa_projects_all.org_id%TYPE;
170: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;

Line 515: FROM pa_tasks

511: IF ( p_task_id IS NOT NULL ) THEN
512: IF ( p_labor_cost_multi_name IS NULL ) THEN
513: SELECT labor_cost_multiplier_name
514: INTO l_labor_cost_mult_name
515: FROM pa_tasks
516: WHERE task_id = p_task_id;
517: ELSE
518: l_labor_cost_mult_name := p_labor_cost_multi_name;
519: END IF;

Line 844: from pa_tasks

840: if p_task_id is not null then
841: -- get the task number details
842: select task_number
843: into pa_pay_util.g_task_number
844: from pa_tasks
845: where task_id = p_task_id;
846:
847: -- get the default work type information from the task
848: begin

Line 851: from pa_work_types_vl a, pa_tasks b

847: -- get the default work type information from the task
848: begin
849: select name
850: into pa_pay_util.g_work_type_name
851: from pa_work_types_vl a, pa_tasks b
852: where a.work_type_id = b.work_type_id
853: and b.task_id = p_task_id;
854:
855: exception

Line 2110: l_labor_cost_mult_name pa_tasks.labor_cost_multiplier_name%TYPE;

2106:
2107: l_forecast_job_id pa_project_assignments.fcst_job_id%TYPE;
2108: l_forecast_job_group_id pa_project_assignments.fcst_job_group_id%TYPE;
2109:
2110: l_labor_cost_mult_name pa_tasks.labor_cost_multiplier_name%TYPE;
2111:
2112:
2113:
2114: l_project_type pa_project_types_all.project_type%TYPE;

Line 2297: FROM pa_tasks

2293: IF ( p_task_id IS NOT NULL ) THEN
2294: BEGIN
2295: SELECT labor_cost_multiplier_name
2296: INTO l_labor_cost_mult_name
2297: FROM pa_tasks
2298: WHERE task_id = p_task_id;
2299: END;
2300: END IF;
2301:

Line 2573: from pa_tasks

2569: if p_task_id is not null then
2570: -- get the task number details
2571: select task_number
2572: into pa_pay_util.g_task_number
2573: from pa_tasks
2574: where task_id = p_task_id;
2575:
2576: -- get the default work type information from the task
2577: begin

Line 2580: from pa_work_types_vl a, pa_tasks b

2576: -- get the default work type information from the task
2577: begin
2578: select name
2579: into pa_pay_util.g_work_type_name
2580: from pa_work_types_vl a, pa_tasks b
2581: where a.work_type_id = b.work_type_id
2582: and b.task_id = p_task_id;
2583:
2584: exception