APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_TASKS

Line 10: g_api_task_id pa_tasks.task_id%type;

6: -- For R12
7: g_input_bvid pa_budget_versions.budget_version_id%type;
8: g_current_baseline_bvid pa_budget_versions.budget_version_id%type;
9: g_api_project_id pa_budget_versions.project_id%type;
10: g_api_task_id pa_tasks.task_id%type;
11: g_api_top_task_id pa_tasks.top_task_id%type;
12: g_api_rlmi pa_resource_list_members.resource_list_member_id%type;
13: g_api_parent_rlmi pa_resource_list_members.parent_member_id%type;
14: g_txn_exists_for_bvid Varchar2(1);

Line 11: g_api_top_task_id pa_tasks.top_task_id%type;

7: g_input_bvid pa_budget_versions.budget_version_id%type;
8: g_current_baseline_bvid pa_budget_versions.budget_version_id%type;
9: g_api_project_id pa_budget_versions.project_id%type;
10: g_api_task_id pa_tasks.task_id%type;
11: g_api_top_task_id pa_tasks.top_task_id%type;
12: g_api_rlmi pa_resource_list_members.resource_list_member_id%type;
13: g_api_parent_rlmi pa_resource_list_members.parent_member_id%type;
14: g_txn_exists_for_bvid Varchar2(1);
15: -- R12 complete

Line 95: FROM pa_tasks t,

91: this is fixed without logging any bugs.
92: SELECT t.cost_ind_rate_sch_id,
93: t.cost_ind_sch_fixed_date
94: INTO l_sch_id ,l_sch_date
95: FROM pa_tasks t,
96: pa_ind_rate_schedules irs
97: WHERE t.task_id = p_task_id
98: AND t.cost_ind_rate_sch_id = irs.ind_rate_sch_id
99: AND irs.cost_ovr_sch_flag = 'Y';

Line 106: FROM pa_tasks t,

102: -- then select the Project level override
103: SELECT irs.ind_rate_sch_id,
104: t.cost_ind_sch_fixed_date
105: INTO l_sch_id,l_sch_date
106: FROM pa_tasks t,
107: pa_ind_rate_schedules irs
108: WHERE t.task_id = p_task_id
109: AND t.task_id = irs.task_id
110: AND irs.cost_ovr_sch_flag = 'Y';

Line 120: FROM pa_tasks t,

116: BEGIN
117: SELECT irs.ind_rate_sch_id,
118: p.cost_ind_sch_fixed_date
119: INTO l_sch_id,l_sch_date
120: FROM pa_tasks t,
121: pa_projects_all p,
122: pa_ind_rate_schedules irs
123: WHERE t.task_id = p_task_id
124: AND t.project_id = p.project_id

Line 136: FROM pa_tasks t,

132: BEGIN
133: SELECT t.cost_ind_rate_sch_id,
134: t.cost_ind_sch_fixed_date
135: INTO l_sch_id ,l_sch_date
136: FROM pa_tasks t,
137: pa_ind_rate_schedules irs
138: WHERE t.task_id = p_task_id
139: AND t.cost_ind_rate_sch_id = irs.ind_rate_sch_id;
140: EXCEPTION

Line 1149: pa_tasks pt

1145: Begin
1146: Select 'T'
1147: into l_budget_entry_level_code
1148: from pa_resource_assignments pra,
1149: pa_tasks pt
1150: where pra.resource_assignment_id = P_resource_assignment_id
1151: and pra.budget_version_id = P_budget_version_id
1152: and pt.task_id = pra.task_id
1153: and pt.top_task_id = pra.task_id;

Line 1196: from pa_tasks where task_id = l_task_id;

1192: If l_budget_entry_level_code = 'P' then
1193: g_api_top_task_id := 0;
1194: Else
1195: select top_task_id into g_api_top_task_id
1196: from pa_tasks where task_id = l_task_id;
1197:
1198: g_api_task_id := l_task_id;
1199: End if;
1200: End If;

Line 1546: -- top task id is determined from pa_tasks

1542:
1543: -- # Determine entry level code if its 'M'.
1544: If p_entry_level_code = 'M' then
1545: -- task_id being passed is that on pa_resource_assignments ...
1546: -- top task id is determined from pa_tasks
1547: If p_task_id = p_top_task_id then
1548: l_budget_entry_level_code := 'T';
1549: Else
1550: l_budget_entry_level_code := 'L';