DBA Data[Home] [Help]

APPS.PA_CALC_OVERTIME dependencies on PA_PROJECTS

Line 494: ,pa_projects p

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:
498: BEGIN

Line 969: , pa_projects p

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;
973: x_count := x_count+1;