eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ALLOC_RUN dependencies on PA_TASKS

Line 777: FROM pa_tasks pt

773: CURSOR C_check_task( p_project_id IN NUMBER
774: , p_task_id IN NUMBER
775: , p_expnd_item_date IN DATE ) IS
776: SELECT 1
777: FROM pa_tasks pt
778: WHERE pt.task_id = p_task_id
779: AND nvl(pt.chargeable_flag, 'N') = 'Y'
780: AND ( trunc(p_expnd_item_date) BETWEEN trunc(nvl(pt.start_date,p_expnd_item_date))
781: AND trunc(NVL(pt.completion_date, p_expnd_item_date)) )

Line 797: FROM pa_tasks

793: WHERE rule_id = p_rule_id;
794: CURSOR C_billable_task( p_task_id IN NUMBER
795: , p_billable_only_flag IN VARCHAR2 ) IS
796: SELECT 1
797: FROM pa_tasks
798: WHERE task_id = p_task_id
799: AND billable_flag = p_billable_only_flag;
800: v_src_error_found BOOLEAN;
801: v_gl_error_found BOOLEAN;

Line 1209: || ' (select pt1.task_id FROM pa_tasks pt1 '

1205: l_proj_id_str := ' pp.project_id = :lp_project_id ' ;
1206: l_task_id_str := ' ( (pt.task_id = :lp_task_id AND '
1207: || ' pa_task_utils.check_child_exists(:lp_task_id)=0) OR '
1208: || ' (pt.top_task_id = :lp_task_id AND pt.task_id in '
1209: || ' (select pt1.task_id FROM pa_tasks pt1 '
1210: || ' WHERE pt1.top_task_id = :lp_task_id '
1211: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;
1212: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1213: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;

Line 1213: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;

1209: || ' (select pt1.task_id FROM pa_tasks pt1 '
1210: || ' WHERE pt1.top_task_id = :lp_task_id '
1211: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;
1212: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1213: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;
1214: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;
1215: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1216: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1217: l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N''' ;

Line 1214: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;

1210: || ' WHERE pt1.top_task_id = :lp_task_id '
1211: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;
1212: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1213: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;
1214: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;
1215: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1216: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1217: l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N''' ;
1218: l_where_str2 := ' pa_task_utils.check_child_exists(pt.task_id)=0' ;

Line 1286: FROM pa_tasks

1282: ORDER BY exclude_flag, line_num;
1283: source_lines_rec c_alloc_source_lines%ROWTYPE;
1284: CURSOR c_leaf_tasks_under_task(p_tsk_id IN NUMBER) IS
1285: SELECT task_id
1286: FROM pa_tasks
1287: WHERE top_task_id = p_tsk_id
1288: AND pa_task_utils.check_child_exists(task_id) = 0;
1289: leaf_task_rec c_leaf_tasks_under_task%ROWTYPE;
1290: CURSOR c_leaf_tasks_under_proj(p_proj_id IN NUMBER) IS

Line 1292: FROM pa_tasks

1288: AND pa_task_utils.check_child_exists(task_id) = 0;
1289: leaf_task_rec c_leaf_tasks_under_task%ROWTYPE;
1290: CURSOR c_leaf_tasks_under_proj(p_proj_id IN NUMBER) IS
1291: SELECT task_id
1292: FROM pa_tasks
1293: WHERE project_id = p_proj_id
1294: AND pa_task_utils.check_child_exists(task_id) = 0;
1295: CURSOR c_alloc_run_src_projects IS
1296: SELECT project_id, task_id

Line 1303: FROM pa_tasks

1299: AND run_id = p_run_id;
1300: RUN_SRC_PROJ_REC c_alloc_run_src_projects%ROWTYPE;
1301: CURSOR C_top_task (p_tsk_id IN NUMBER)IS
1302: SELECT top_task_id
1303: FROM pa_tasks
1304: WHERE top_task_id = p_tsk_id;
1305: v_top_task_id NUMBER;
1306: v_retcode NUMBER;
1307: v_dummy NUMBER;

Line 1945: || ' (select pt1.task_id FROM pa_tasks pt1 '

1941: l_class_code_str:= ' pc.class_code = :lp_class_code ' ;
1942: l_proj_id_str := ' pp.project_id = :lp_project_id ' ;
1943: l_task_id_str := ' ( (pt.task_id =:lp_task_id AND pt.chargeable_flag=''Y'') OR '
1944: || ' (pt.top_task_id = :lp_task_id AND pt.task_id in '
1945: || ' (select pt1.task_id FROM pa_tasks pt1 '
1946: || ' WHERE pt1.top_task_id = :lp_task_id '
1947: || ' AND pt1.chargeable_flag = ''Y'' )))' ;
1948: l_billable_str := ' pt.billable_flag = :lp_billable_only_flag ' ;
1949: l_expnd_item_str:= ' :p_expnd_item_date BETWEEN nvl(pt.start_date,:p_expnd_item_date) AND NVL(pt.completion_date, :p_expnd_item_date) ' ;

Line 1952: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp ' ;

1948: l_billable_str := ' pt.billable_flag = :lp_billable_only_flag ' ;
1949: l_expnd_item_str:= ' :p_expnd_item_date BETWEEN nvl(pt.start_date,:p_expnd_item_date) AND NVL(pt.completion_date, :p_expnd_item_date) ' ;
1950: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1951: if p_limit_target_projects_code = 'O' then
1952: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp ' ;
1953: l_from_str2 := ' From pa_tasks pt, pa_projects pp ' ;
1954: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1955: else
1956: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;

Line 1953: l_from_str2 := ' From pa_tasks pt, pa_projects pp ' ;

1949: l_expnd_item_str:= ' :p_expnd_item_date BETWEEN nvl(pt.start_date,:p_expnd_item_date) AND NVL(pt.completion_date, :p_expnd_item_date) ' ;
1950: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1951: if p_limit_target_projects_code = 'O' then
1952: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp ' ;
1953: l_from_str2 := ' From pa_tasks pt, pa_projects pp ' ;
1954: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1955: else
1956: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1957: l_from_str2 := ' From pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;

Line 1956: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;

1952: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp ' ;
1953: l_from_str2 := ' From pa_tasks pt, pa_projects pp ' ;
1954: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1955: else
1956: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1957: l_from_str2 := ' From pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1958: --l_where_str0 := ' where pp.project_id = pt.project_id AND nvl(pp.org_id,''0'') = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1959: l_where_str0 := ' where pp.project_id = pt.project_id AND pp.org_id = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1960: if p_limit_target_projects_code = 'L' then

Line 1957: l_from_str2 := ' From pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;

1953: l_from_str2 := ' From pa_tasks pt, pa_projects pp ' ;
1954: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1955: else
1956: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1957: l_from_str2 := ' From pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1958: --l_where_str0 := ' where pp.project_id = pt.project_id AND nvl(pp.org_id,''0'') = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1959: l_where_str0 := ' where pp.project_id = pt.project_id AND pp.org_id = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1960: if p_limit_target_projects_code = 'L' then
1961: l_where_str0 := l_where_str0 || 'pcou.prvdr_legal_entity_id = pcou.recvr_legal_entity_id AND ' ;

Line 2054: from pa_tasks pt

2050: target_lines_rec c_alloc_target_lines%ROWTYPE;
2051: Cursor c_chargeable_tasks_in_proj (x_project_id IN NUMBER,
2052: x_ei_date IN DATE ) is
2053: select project_id, task_id
2054: from pa_tasks pt
2055: where pt.project_id = x_project_id
2056: AND pt.chargeable_flag = 'Y'
2057: AND x_ei_date between nvl(pt.start_date,x_ei_date) and nvl(pt.completion_date,x_ei_date) ;
2058: CURSOR c_alloc_run_trg_projects IS

Line 9539: , pa_tasks pt

9535: ,pa_utils4.GetOrgBusinessGrpId(run_rec.offset_exp_org_id)))
9536: /* end of performance changes */
9537: from pa_alloc_txn_details patd
9538: , pa_projects_all pp
9539: , pa_tasks pt
9540: where patd.run_id = p_run_id
9541: and patd.project_id = pp.project_id
9542: and patd.task_id = pt.task_id ;
9543: IF P_DEBUG_MODE = 'Y' THEN