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 785: FROM pa_tasks pt

781: CURSOR C_check_task( p_project_id IN NUMBER
782: , p_task_id IN NUMBER
783: , p_expnd_item_date IN DATE ) IS
784: SELECT 1
785: FROM pa_tasks pt
786: WHERE pt.task_id = p_task_id
787: AND nvl(pt.chargeable_flag, 'N') = 'Y'
788: AND ( trunc(p_expnd_item_date) BETWEEN trunc(nvl(pt.start_date,p_expnd_item_date))
789: AND trunc(NVL(pt.completion_date, p_expnd_item_date)) )

Line 805: FROM pa_tasks

801: WHERE rule_id = p_rule_id;
802: CURSOR C_billable_task( p_task_id IN NUMBER
803: , p_billable_only_flag IN VARCHAR2 ) IS
804: SELECT 1
805: FROM pa_tasks
806: WHERE task_id = p_task_id
807: AND billable_flag = p_billable_only_flag;
808: v_src_error_found BOOLEAN;
809: v_gl_error_found BOOLEAN;

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

1213: l_proj_id_str := ' pp.project_id = :lp_project_id ' ;
1214: l_task_id_str := ' ( (pt.task_id = :lp_task_id AND '
1215: || ' pa_task_utils.check_child_exists(:lp_task_id)=0) OR '
1216: || ' (pt.top_task_id = :lp_task_id AND pt.task_id in '
1217: || ' (select pt1.task_id FROM pa_tasks pt1 '
1218: || ' WHERE pt1.top_task_id = :lp_task_id '
1219: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;
1220: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1221: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;

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

1217: || ' (select pt1.task_id FROM pa_tasks pt1 '
1218: || ' WHERE pt1.top_task_id = :lp_task_id '
1219: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;
1220: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1221: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;
1222: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;
1223: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1224: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1225: --l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N''' ; commented as part of the bug 13949738

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

1218: || ' WHERE pt1.top_task_id = :lp_task_id '
1219: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;
1220: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1221: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;
1222: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;
1223: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1224: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1225: --l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N''' ; commented as part of the bug 13949738
1226: l_where_str2 := ' pa_task_utils.check_child_exists(pt.task_id)=0' ;

Line 1296: FROM pa_tasks

1292: ORDER BY exclude_flag, line_num;
1293: source_lines_rec c_alloc_source_lines%ROWTYPE;
1294: CURSOR c_leaf_tasks_under_task(p_tsk_id IN NUMBER) IS
1295: SELECT task_id
1296: FROM pa_tasks
1297: WHERE top_task_id = p_tsk_id
1298: AND pa_task_utils.check_child_exists(task_id) = 0;
1299: leaf_task_rec c_leaf_tasks_under_task%ROWTYPE;
1300: CURSOR c_leaf_tasks_under_proj(p_proj_id IN NUMBER) IS

Line 1302: FROM pa_tasks

1298: AND pa_task_utils.check_child_exists(task_id) = 0;
1299: leaf_task_rec c_leaf_tasks_under_task%ROWTYPE;
1300: CURSOR c_leaf_tasks_under_proj(p_proj_id IN NUMBER) IS
1301: SELECT task_id
1302: FROM pa_tasks
1303: WHERE project_id = p_proj_id
1304: AND pa_task_utils.check_child_exists(task_id) = 0;
1305: CURSOR c_alloc_run_src_projects IS
1306: SELECT project_id, task_id

Line 1313: FROM pa_tasks

1309: AND run_id = p_run_id;
1310: RUN_SRC_PROJ_REC c_alloc_run_src_projects%ROWTYPE;
1311: CURSOR C_top_task (p_tsk_id IN NUMBER)IS
1312: SELECT top_task_id
1313: FROM pa_tasks
1314: WHERE top_task_id = p_tsk_id;
1315: v_top_task_id NUMBER;
1316: v_retcode NUMBER;
1317: v_dummy NUMBER;

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

1951: l_class_code_str:= ' pc.class_code = :lp_class_code ' ;
1952: l_proj_id_str := ' pp.project_id = :lp_project_id ' ;
1953: l_task_id_str := ' ( (pt.task_id =:lp_task_id AND pt.chargeable_flag=''Y'') OR '
1954: || ' (pt.top_task_id = :lp_task_id AND pt.task_id in '
1955: || ' (select pt1.task_id FROM pa_tasks pt1 '
1956: || ' WHERE pt1.top_task_id = :lp_task_id '
1957: || ' AND pt1.chargeable_flag = ''Y'' )))' ;
1958: l_billable_str := ' pt.billable_flag = :lp_billable_only_flag ' ;
1959: 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 1962: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp ' ;

1958: l_billable_str := ' pt.billable_flag = :lp_billable_only_flag ' ;
1959: 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) ' ;
1960: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1961: if p_limit_target_projects_code = 'O' then
1962: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp ' ;
1963: l_from_str2 := ' From pa_tasks pt, pa_projects pp ' ;
1964: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1965: else
1966: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;

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

1959: 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) ' ;
1960: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1961: if p_limit_target_projects_code = 'O' then
1962: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp ' ;
1963: l_from_str2 := ' From pa_tasks pt, pa_projects pp ' ;
1964: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1965: else
1966: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1967: l_from_str2 := ' From pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;

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

1962: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp ' ;
1963: l_from_str2 := ' From pa_tasks pt, pa_projects pp ' ;
1964: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1965: else
1966: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1967: l_from_str2 := ' From pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1968: --l_where_str0 := ' where pp.project_id = pt.project_id AND nvl(pp.org_id,''0'') = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1969: l_where_str0 := ' where pp.project_id = pt.project_id AND pp.org_id = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1970: if p_limit_target_projects_code = 'L' then

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

1963: l_from_str2 := ' From pa_tasks pt, pa_projects pp ' ;
1964: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1965: else
1966: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1967: l_from_str2 := ' From pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1968: --l_where_str0 := ' where pp.project_id = pt.project_id AND nvl(pp.org_id,''0'') = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1969: l_where_str0 := ' where pp.project_id = pt.project_id AND pp.org_id = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1970: if p_limit_target_projects_code = 'L' then
1971: l_where_str0 := l_where_str0 || 'pcou.prvdr_legal_entity_id = pcou.recvr_legal_entity_id AND ' ;

Line 2064: from pa_tasks pt

2060: target_lines_rec c_alloc_target_lines%ROWTYPE;
2061: Cursor c_chargeable_tasks_in_proj (x_project_id IN NUMBER,
2062: x_ei_date IN DATE ) is
2063: select project_id, task_id
2064: from pa_tasks pt
2065: where pt.project_id = x_project_id
2066: AND pt.chargeable_flag = 'Y'
2067: AND x_ei_date between nvl(pt.start_date,x_ei_date) and nvl(pt.completion_date,x_ei_date) ;
2068: CURSOR c_alloc_run_trg_projects IS

Line 9644: , pa_tasks pt

9640: ,pa_utils4.GetOrgBusinessGrpId(run_rec.offset_exp_org_id)))
9641: /* end of performance changes */
9642: from pa_alloc_txn_details patd
9643: , pa_projects_all pp
9644: , pa_tasks pt
9645: where patd.run_id = p_run_id
9646: and patd.project_id = pp.project_id
9647: and patd.task_id = pt.task_id ;
9648: IF P_DEBUG_MODE = 'Y' THEN