APPS.PA_REVENUE dependencies on PA_TASKS

Line 295: FROM pa_tasks

291: SELECT labor_schedule_discount,labor_bill_rate_org_id,labor_std_bill_rate_schdl,
292: labor_schedule_fixed_date,labor_sch_type
293: INTO l_labor_schdl_discnt,l_labor_bill_rate_org_id,l_labor_std_bill_rate_schdl,
294: l_labor_schdl_fixed_date,l_labor_sch_type
295: FROM pa_tasks
296: WHERE task_id = p_task_id;
297: EXCEPTION
298: WHEN NO_DATA_FOUND THEN
299: NULL;

Line 1015: FROM pa_tasks

1011: SELECT labor_schedule_discount,labor_bill_rate_org_id,labor_std_bill_rate_schdl,
1012: labor_schedule_fixed_date,labor_sch_type
1013: INTO l_labor_schdl_discnt,l_labor_bill_rate_org_id,l_labor_std_bill_rate_schdl,
1014: l_labor_schdl_fixed_date,l_labor_sch_type
1015: FROM pa_tasks
1016: WHERE task_id = p_task_id;
1017: EXCEPTION
1018: WHEN NO_DATA_FOUND THEN
1019: NULL;

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

2070: DECODE(l_discount_percentage,NULL,'B','O'),
2071: nvl(l_discount_percentage,l_labor_schdl_discnt)
2072: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,
2073: l_amount_calculation_code,l_discount_percentage
2074: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao, pa_tasks t
2075: WHERE ao.person_id = p_person_id
2076: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2077: AND b.job_id = ao.job_id
2078: -- AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 *//*commented for bug 9257637 */

Line 3326: FROM pa_tasks

3322: WHERE project_id=p_project_id;
3323:
3324: SELECT non_lab_std_bill_rt_sch_id
3325: into l_task_std_bill_rate_sch_id
3326: FROM pa_tasks
3327: WHERE task_id=p_task_id; */
3328:
3329: l_proj_std_bill_rate_sch_id := p_proj_nl_std_bill_rate_sch_id;
3330: l_task_std_bill_rate_sch_id := p_task_nl_std_bill_rate_sch_id;