DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PA_TASK_ASSIGNMENTS_V

Line 236: l_resource_class_code PA_TASK_ASSIGNMENTS_V.RESOURCE_CLASS_CODE%TYPE;

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

Line 21501: l_resource_class_code pa_task_assignments_v.resource_class_code%TYPE;

21497: l_new_object_id NUMBER;
21498: l_actuals_pushed VARCHAR2(1) :='N';
21499: l_msg_code VARCHAR2(32);
21500: l_src_str_ver_publsihed VARCHAR2(1);
21501: l_resource_class_code pa_task_assignments_v.resource_class_code%TYPE;
21502: L_TXN_CURRENCY_CODE pa_task_assignments_v.txn_currency_code%TYPE;
21503: L_RATE_BASED_FLAG varchar2(1);
21504: L_RBS_ELEMENT_ID number;
21505: l_prog_mode varchar2(1);

Line 21502: L_TXN_CURRENCY_CODE pa_task_assignments_v.txn_currency_code%TYPE;

21498: l_actuals_pushed VARCHAR2(1) :='N';
21499: l_msg_code VARCHAR2(32);
21500: l_src_str_ver_publsihed VARCHAR2(1);
21501: l_resource_class_code pa_task_assignments_v.resource_class_code%TYPE;
21502: L_TXN_CURRENCY_CODE pa_task_assignments_v.txn_currency_code%TYPE;
21503: L_RATE_BASED_FLAG varchar2(1);
21504: L_RBS_ELEMENT_ID number;
21505: l_prog_mode varchar2(1);
21506:

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

21521: CURSOR cur_select_all_assgns
21522: IS
21523: SELECT ptav.*
21524: FROM pa_progress_rollup ppr2
21525: --,pa_task_assignments_v ptav --bug 3967374
21526: ,pa_task_asgmts_v ptav
21527: WHERE ppr2.project_id=p_project_id
21528: AND ptav.project_id=p_project_id
21529: AND ppr2.object_id = ptav.task_id