DBA Data[Home] [Help]

APPS.PA_CALC_OVERTIME dependencies on PA_TASKS

Line 493: from pa_tasks t

489:
490: cursor get_proj_id IS
491: select p.project_id
492: ,p.projfunc_currency_code
493: from pa_tasks t
494: ,pa_projects p
495: where t.task_id = Temp_Task
496: and t.project_id = p.project_id;
497:

Line 968: FROM pa_tasks t

964: , t.labor_cost_multiplier_name overtime_LCM
965: , t.task_name overtime_task_name
966: , p.project_currency_code proj_curr_code
967: , p.projfunc_currency_code projfunc_currency_code
968: FROM pa_tasks t
969: , pa_projects p
970: WHERE t.project_id = p.project_id
971: AND p.segment1 = 'OT') LOOP
972: EXIT WHEN x_count >= 5;