APPS.PA_ACC_GEN_WF_PKG dependencies on PA_ALTERNATE_TASKS

Line 524: pa_alternate_tasks alt

520: FROM
521: HR_Organization_Units ORG,
522: PA_Tasks TOP_TASK,
523: PA_Tasks TASK,
524: pa_alternate_tasks alt
525: WHERE alt.alt_task_id = p_task_id
526: AND TASK.task_id = alt.proj_element_id
527: AND ORG.organization_id = TASK.carrying_out_organization_id
528: AND TASK.Top_Task_ID = TOP_TASK.Task_ID;

Line 869: from pa_alternate_tasks

865: l_task_id := p_task_id;
866: ELSE
867: BEGIN
868: select proj_element_id into l_task_id
869: from pa_alternate_tasks
870: where alt_task_id = p_task_id;
871: EXCEPTION
872: WHEN OTHERS THEN
873: l_task_id := p_task_id;

Line 1663: from pa_alternate_tasks

1659: l_task_id := p_task_id;
1660: ELSE
1661: BEGIN
1662: select proj_element_id into l_task_id
1663: from pa_alternate_tasks
1664: where alt_task_id = p_task_id;
1665: EXCEPTION
1666: WHEN OTHERS THEN
1667: l_task_id := p_task_id;