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 1096: pa_tasks tsk,

1092: NVL(tsk.project_rate_type, imp.default_rate_type)
1093: INTO l_projfunc_rate_date,
1094: l_projfunc_rate_type
1095: FROM pa_projects_all prj,
1096: pa_tasks tsk,
1097: pa_implementations_all imp
1098: WHERE prj.project_id = p_project_id
1099: AND prj.project_id = tsk.project_id
1100: AND tsk.task_id = p_task_id

Line 1695: FROM pa_tasks t,

1691: 'REVENUE', t.rev_ind_sch_fixed_date,
1692: 'INVOICE', t.inv_ind_sch_fixed_date)
1693: INTO l_burden_sch_id,
1694: l_burden_sch_fixed_date
1695: FROM pa_tasks t,
1696: pa_ind_rate_schedules irs
1697: WHERE t.task_id = p_task_id
1698: AND t.task_id = irs.task_id
1699: AND ( (p_schedule_type = 'COST'

Line 1874: FROM pa_tasks t

1870: 'REVENUE', t.rev_ind_sch_fixed_date,
1871: 'INVOICE', t.inv_ind_sch_fixed_date)
1872: INTO l_burden_sch_id,
1873: l_burden_sch_fixed_date
1874: FROM pa_tasks t
1875: WHERE t.task_id = p_task_id
1876: AND ( p_schedule_type = 'COST'
1877: OR p_schedule_type = 'REVENUE'
1878: OR p_schedule_type = 'INVOICE'

Line 2085: l_ot_task_id pa_tasks.task_id%type;

2081: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
2082: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
2083: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
2084: l_ot_project_id pa_projects_all.project_id%type;
2085: l_ot_task_id pa_tasks.task_id%type;
2086: l_err_code varchar2(200);
2087: l_err_stage number;
2088: l_return_value varchar2(100);
2089: user_exception EXCEPTION;