APPS.PA_COST dependencies on PA_TASKS

Line 67: l_ot_task_id pa_tasks.task_id%type;

63: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
64: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
65: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
66: l_ot_project_id pa_projects_all.project_id%type;
67: l_ot_task_id pa_tasks.task_id%type;
68: l_err_code varchar2(200);
69: l_err_stage number;
70: l_return_value varchar2(100);
71: l_numerator number;

Line 1063: pa_tasks tsk,

1059: NVL(tsk.project_rate_type, imp.default_rate_type)
1060: INTO l_projfunc_rate_date,
1061: l_projfunc_rate_type
1062: FROM pa_projects_all prj,
1063: pa_tasks tsk,
1064: pa_implementations_all imp
1065: WHERE prj.project_id = p_project_id
1066: AND prj.project_id = tsk.project_id
1067: AND tsk.task_id = p_task_id

Line 1662: FROM pa_tasks t,

1658: 'REVENUE', t.rev_ind_sch_fixed_date,
1659: 'INVOICE', t.inv_ind_sch_fixed_date)
1660: INTO l_burden_sch_id,
1661: l_burden_sch_fixed_date
1662: FROM pa_tasks t,
1663: pa_ind_rate_schedules irs
1664: WHERE t.task_id = p_task_id
1665: AND t.task_id = irs.task_id
1666: AND ( (p_schedule_type = 'COST'

Line 1841: FROM pa_tasks t

1837: 'REVENUE', t.rev_ind_sch_fixed_date,
1838: 'INVOICE', t.inv_ind_sch_fixed_date)
1839: INTO l_burden_sch_id,
1840: l_burden_sch_fixed_date
1841: FROM pa_tasks t
1842: WHERE t.task_id = p_task_id
1843: AND ( p_schedule_type = 'COST'
1844: OR p_schedule_type = 'REVENUE'
1845: OR p_schedule_type = 'INVOICE'

Line 2052: l_ot_task_id pa_tasks.task_id%type;

2048: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
2049: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
2050: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
2051: l_ot_project_id pa_projects_all.project_id%type;
2052: l_ot_task_id pa_tasks.task_id%type;
2053: l_err_code varchar2(200);
2054: l_err_stage number;
2055: l_return_value varchar2(100);
2056: user_exception EXCEPTION;