APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_TASKS

Line 3179: From pa_tasks t

3175: (p_record.entry_level_code = 'P' and p_record.bud_task_id = 0)
3176: OR
3177: (p_record.entry_level_code = 'T'
3178: and p_record.bud_task_id = pb.top_task_id /* (select t.top_task_id
3179: From pa_tasks t
3180: Where t.task_id = pb.task_id) 7531681 */
3181: )
3182: OR
3183: (p_record.entry_level_code = 'M'

Line 3187: From pa_tasks t

3183: (p_record.entry_level_code = 'M'
3184: and ( p_record.bud_task_id = pb.task_id
3185: OR
3186: p_record.bud_task_id = pb.top_task_id /* (select t.top_task_id
3187: From pa_tasks t
3188: Where t.task_id = pb.task_id) 7531681 */
3189: )
3190: )))
3191: )

Line 3303: From pa_tasks t

3299: (p_record.entry_level_code = 'P' and p_record.bud_task_id = 0)
3300: OR
3301: (p_record.entry_level_code = 'T'
3302: and p_record.bud_task_id = pb.top_task_id /*(select t.top_task_id
3303: From pa_tasks t
3304: Where t.task_id = pb.task_id) 7531681 */
3305: )
3306: OR
3307: (p_record.entry_level_code = 'M'

Line 3311: From pa_tasks t

3307: (p_record.entry_level_code = 'M'
3308: and (p_record.bud_task_id = pb.task_id
3309: OR
3310: p_record.bud_task_id = pb.top_task_id /* (select t.top_task_id
3311: From pa_tasks t
3312: Where t.task_id = pb.task_id) 7531681 */
3313: )
3314: )))
3315: )

Line 3367: From pa_tasks t

3363: (p_record.entry_level_code = 'P' and p_record.bud_task_id = 0)
3364: OR
3365: (p_record.entry_level_code = 'T'
3366: and p_record.bud_task_id = pb.top_task_id /* (select t.top_task_id
3367: From pa_tasks t
3368: Where t.task_id = pb.task_id) 7531681 */
3369: )
3370: OR
3371: (p_record.entry_level_code = 'M'

Line 3375: From pa_tasks t

3371: (p_record.entry_level_code = 'M'
3372: and ( p_record.bud_task_id = pb.task_id
3373: OR
3374: p_record.bud_task_id = pb.top_task_id /* (select t.top_task_id
3375: From pa_tasks t
3376: Where t.task_id = pb.task_id) 7531681 */
3377: )
3378: )))
3379: )

Line 3490: From pa_tasks t

3486: (p_record.entry_level_code = 'P' and p_record.bud_task_id = 0)
3487: OR
3488: (p_record.entry_level_code = 'T'
3489: and l_task_id = pb.top_task_id /* (select t.top_task_id
3490: From pa_tasks t
3491: Where t.task_id = pb.task_id) 7531681 */
3492: )
3493: OR
3494: (p_record.entry_level_code = 'M'

Line 3498: From pa_tasks t

3494: (p_record.entry_level_code = 'M'
3495: and ( pb.task_id = l_task_id
3496: OR
3497: l_task_id = pb.top_task_id /* (select t.top_task_id
3498: From pa_tasks t
3499: Where t.task_id = pb.task_id) 7531681 */
3500: )
3501: )))
3502: )

Line 6760: FROM pa_tasks

6756: WHERE budget_version_id = l_bdgt_version_id
6757: AND project_id = l_project_id
6758: AND balance_type = 'BGT'
6759: AND task_id = (SELECT top_task_id
6760: FROM pa_tasks
6761: WHERE task_id = l_task_id
6762: );
6763:
6764:

Line 6780: FROM pa_tasks

6776: log_message(p_msg_token1 => 'p_entry_level_code= '||p_entry_level_code);
6777: End if;
6778: SELECT top_task_id
6779: INTO l_top_task_id
6780: FROM pa_tasks
6781: WHERE task_id = p_task_id;
6782:
6783: If p_entry_level_code in ('P', 'L', 'T' ) then
6784: If p_entry_level_code = 'P' then

Line 6801: -- pa_bc_balacnes for the toptask in pa_tasks

6797: ---------------------------------------------------------------------------------
6798: -- if the budget entry level = 'M' update by record.first select the budget task id
6799: -- (LOW TASK)based on the project,task,budget version from pa_bc_balances if not found then
6800: -- select the budget task id(TOP TASK) based on the project,task,budget version from
6801: -- pa_bc_balacnes for the toptask in pa_tasks
6802: -------------------------------------------------------------------------------------
6803: OPEN cur_low_task_id( p_project_id,
6804: p_task_id,
6805: p_budget_version_id);

Line 15631: from pa_tasks

15627: end loop;
15628: Else
15629: for x in t_Task_id.FIRST..t_task_id.LAST loop
15630: select top_task_id into t_top_task_id(x)
15631: from pa_tasks
15632: where task_id = t_task_id(x);
15633: end loop;
15634: End If;
15635: