APPS.PA_PROGRESS_PUB dependencies on PA_TASK_ASSIGNMENTS_V

Line 235: l_resource_class_code PA_TASK_ASSIGNMENTS_V.RESOURCE_CLASS_CODE%TYPE;

231: l_projfunc_res_burden_rate NUMBER;
232:
233: l_rate_based_flag VARCHAR2(1);
234: l_rbs_element_id NUMBER;
235: l_resource_class_code PA_TASK_ASSIGNMENTS_V.RESOURCE_CLASS_CODE%TYPE;
236: l_budget_version_id NUMBER;
237:
238: l_progress_exists VARCHAR2(1) :='N';
239:

Line 20038: l_resource_class_code pa_task_assignments_v.resource_class_code%TYPE;

20034: l_new_object_id NUMBER;
20035: l_actuals_pushed VARCHAR2(1) :='N';
20036: l_msg_code VARCHAR2(32);
20037: l_src_str_ver_publsihed VARCHAR2(1);
20038: l_resource_class_code pa_task_assignments_v.resource_class_code%TYPE;
20039: L_TXN_CURRENCY_CODE pa_task_assignments_v.txn_currency_code%TYPE;
20040: L_RATE_BASED_FLAG varchar2(1);
20041: L_RBS_ELEMENT_ID number;
20042: l_prog_mode varchar2(1);

Line 20039: L_TXN_CURRENCY_CODE pa_task_assignments_v.txn_currency_code%TYPE;

20035: l_actuals_pushed VARCHAR2(1) :='N';
20036: l_msg_code VARCHAR2(32);
20037: l_src_str_ver_publsihed VARCHAR2(1);
20038: l_resource_class_code pa_task_assignments_v.resource_class_code%TYPE;
20039: L_TXN_CURRENCY_CODE pa_task_assignments_v.txn_currency_code%TYPE;
20040: L_RATE_BASED_FLAG varchar2(1);
20041: L_RBS_ELEMENT_ID number;
20042: l_prog_mode varchar2(1);
20043:

Line 20062: --,pa_task_assignments_v ptav --bug 3967374

20058: CURSOR cur_select_all_assgns
20059: IS
20060: SELECT ptav.*
20061: FROM pa_progress_rollup ppr2
20062: --,pa_task_assignments_v ptav --bug 3967374
20063: ,pa_task_asgmts_v ptav
20064: WHERE ppr2.project_id=p_project_id
20065: AND ptav.project_id=p_project_id
20066: AND ppr2.object_id = ptav.task_id