APPS.PA_REVENUE dependencies on PA_TASKS

Line 286: FROM pa_tasks

282: SELECT labor_schedule_discount,labor_bill_rate_org_id,labor_std_bill_rate_schdl,
283: labor_schedule_fixed_date,labor_sch_type
284: INTO l_labor_schdl_discnt,l_labor_bill_rate_org_id,l_labor_std_bill_rate_schdl,
285: l_labor_schdl_fixed_date,l_labor_sch_type
286: FROM pa_tasks
287: WHERE task_id = p_task_id;
288: EXCEPTION
289: WHEN NO_DATA_FOUND THEN
290: NULL;

Line 996: FROM pa_tasks

992: SELECT labor_schedule_discount,labor_bill_rate_org_id,labor_std_bill_rate_schdl,
993: labor_schedule_fixed_date,labor_sch_type
994: INTO l_labor_schdl_discnt,l_labor_bill_rate_org_id,l_labor_std_bill_rate_schdl,
995: l_labor_schdl_fixed_date,l_labor_sch_type
996: FROM pa_tasks
997: WHERE task_id = p_task_id;
998: EXCEPTION
999: WHEN NO_DATA_FOUND THEN
1000: NULL;

Line 2055: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao, pa_tasks t

2051: DECODE(l_discount_percentage,NULL,'B','O'),
2052: nvl(l_discount_percentage,l_labor_schdl_discnt)
2053: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,
2054: l_amount_calculation_code,l_discount_percentage
2055: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao, pa_tasks t
2056: WHERE ao.person_id = p_person_id
2057: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2058: AND b.job_id = ao.job_id(+)
2059: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 */

Line 3300: FROM pa_tasks

3296: WHERE project_id=p_project_id;
3297:
3298: SELECT non_lab_std_bill_rt_sch_id
3299: into l_task_std_bill_rate_sch_id
3300: FROM pa_tasks
3301: WHERE task_id=p_task_id; */
3302:
3303: l_proj_std_bill_rate_sch_id := p_proj_nl_std_bill_rate_sch_id;
3304: l_task_std_bill_rate_sch_id := p_task_nl_std_bill_rate_sch_id;