APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_TASKS

Line 3160: From pa_tasks t

3156: (p_record.entry_level_code = 'P' and p_record.bud_task_id = 0)
3157: OR
3158: (p_record.entry_level_code = 'T'
3159: and p_record.bud_task_id = (select t.top_task_id
3160: From pa_tasks t
3161: Where t.task_id = pb.task_id)
3162: )
3163: OR
3164: (p_record.entry_level_code = 'M'

Line 3168: From pa_tasks t

3164: (p_record.entry_level_code = 'M'
3165: and ( p_record.bud_task_id = pb.task_id
3166: OR
3167: p_record.bud_task_id = (select t.top_task_id
3168: From pa_tasks t
3169: Where t.task_id = pb.task_id)
3170: )
3171: )))
3172: )

Line 3275: From pa_tasks t

3271: (p_record.entry_level_code = 'P' and p_record.bud_task_id = 0)
3272: OR
3273: (p_record.entry_level_code = 'T'
3274: and p_record.bud_task_id = (select t.top_task_id
3275: From pa_tasks t
3276: Where t.task_id = pb.task_id)
3277: )
3278: OR
3279: (p_record.entry_level_code = 'M'

Line 3283: From pa_tasks t

3279: (p_record.entry_level_code = 'M'
3280: and (p_record.bud_task_id = pb.task_id
3281: OR
3282: p_record.bud_task_id = (select t.top_task_id
3283: From pa_tasks t
3284: Where t.task_id = pb.task_id)
3285: )
3286: )))
3287: )

Line 3336: From pa_tasks t

3332: (p_record.entry_level_code = 'P' and p_record.bud_task_id = 0)
3333: OR
3334: (p_record.entry_level_code = 'T'
3335: and p_record.bud_task_id = (select t.top_task_id
3336: From pa_tasks t
3337: Where t.task_id = pb.task_id)
3338: )
3339: OR
3340: (p_record.entry_level_code = 'M'

Line 3344: From pa_tasks t

3340: (p_record.entry_level_code = 'M'
3341: and ( p_record.bud_task_id = pb.task_id
3342: OR
3343: p_record.bud_task_id = (select t.top_task_id
3344: From pa_tasks t
3345: Where t.task_id = pb.task_id)
3346: )
3347: )))
3348: )

Line 3451: From pa_tasks t

3447: (p_record.entry_level_code = 'P' and p_record.bud_task_id = 0)
3448: OR
3449: (p_record.entry_level_code = 'T'
3450: and l_task_id = (select t.top_task_id
3451: From pa_tasks t
3452: Where t.task_id = pb.task_id)
3453: )
3454: OR
3455: (p_record.entry_level_code = 'M'

Line 3459: From pa_tasks t

3455: (p_record.entry_level_code = 'M'
3456: and ( pb.task_id = l_task_id
3457: OR
3458: l_task_id = (select t.top_task_id
3459: From pa_tasks t
3460: Where t.task_id = pb.task_id)
3461: )
3462: )))
3463: )

Line 6597: FROM pa_tasks

6593: WHERE budget_version_id = l_bdgt_version_id
6594: AND project_id = l_project_id
6595: AND balance_type = 'BGT'
6596: AND task_id = (SELECT top_task_id
6597: FROM pa_tasks
6598: WHERE task_id = l_task_id
6599: );
6600:
6601:

Line 6613: FROM pa_tasks

6609: -- if the budget entry level in 'L','T','P' -- update directly.
6610: -------------------------------------------------------------------------------------------
6611: SELECT top_task_id
6612: INTO l_top_task_id
6613: FROM pa_tasks
6614: WHERE task_id = p_task_id;
6615:
6616: If p_entry_level_code in ('P', 'L', 'T' ) then
6617: If p_entry_level_code = 'P' then

Line 6634: -- pa_bc_balacnes for the toptask in pa_tasks

6630: ---------------------------------------------------------------------------------
6631: -- if the budget entry level = 'M' update by record.first select the budget task id
6632: -- (LOW TASK)based on the project,task,budget version from pa_bc_balances if not found then
6633: -- select the budget task id(TOP TASK) based on the project,task,budget version from
6634: -- pa_bc_balacnes for the toptask in pa_tasks
6635: -------------------------------------------------------------------------------------
6636: OPEN cur_low_task_id( p_project_id,
6637: p_task_id,
6638: p_budget_version_id);

Line 15200: from pa_tasks

15196: end loop;
15197: Else
15198: for x in t_Task_id.FIRST..t_task_id.LAST loop
15199: select top_task_id into t_top_task_id(x)
15200: from pa_tasks
15201: where task_id = t_task_id(x);
15202: end loop;
15203: End If;
15204: