APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_TASKS

Line 13: g_api_task_id pa_tasks.task_id%type;

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

Line 14: g_api_top_task_id pa_tasks.top_task_id%type;

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

Line 123: FROM pa_tasks t,

119: this is fixed without logging any bugs.
120: SELECT t.cost_ind_rate_sch_id,
121: t.cost_ind_sch_fixed_date
122: INTO l_sch_id ,l_sch_date
123: FROM pa_tasks t,
124: pa_ind_rate_schedules irs
125: WHERE t.task_id = p_task_id
126: AND t.cost_ind_rate_sch_id = irs.ind_rate_sch_id
127: AND irs.cost_ovr_sch_flag = 'Y';

Line 134: FROM pa_tasks t,

130: -- then select the Project level override
131: SELECT irs.ind_rate_sch_id,
132: t.cost_ind_sch_fixed_date
133: INTO l_sch_id,l_sch_date
134: FROM pa_tasks t,
135: pa_ind_rate_schedules irs
136: WHERE t.task_id = p_task_id
137: AND t.task_id = irs.task_id
138: AND irs.cost_ovr_sch_flag = 'Y';

Line 148: FROM pa_tasks t,

144: BEGIN
145: SELECT irs.ind_rate_sch_id,
146: p.cost_ind_sch_fixed_date
147: INTO l_sch_id,l_sch_date
148: FROM pa_tasks t,
149: pa_projects_all p,
150: pa_ind_rate_schedules irs
151: WHERE t.task_id = p_task_id
152: AND t.project_id = p.project_id

Line 164: FROM pa_tasks t,

160: BEGIN
161: SELECT t.cost_ind_rate_sch_id,
162: t.cost_ind_sch_fixed_date
163: INTO l_sch_id ,l_sch_date
164: FROM pa_tasks t,
165: pa_ind_rate_schedules irs
166: WHERE t.task_id = p_task_id
167: AND t.cost_ind_rate_sch_id = irs.ind_rate_sch_id;
168: EXCEPTION

Line 1300: pa_tasks pt

1296: Begin
1297: Select 'T'
1298: into l_budget_entry_level_code
1299: from pa_resource_assignments pra,
1300: pa_tasks pt
1301: where pra.resource_assignment_id = P_resource_assignment_id
1302: and pra.budget_version_id = P_budget_version_id
1303: and pt.task_id = pra.task_id
1304: and pt.top_task_id = pra.task_id;

Line 1347: from pa_tasks where task_id = l_task_id;

1343: If l_budget_entry_level_code = 'P' then
1344: g_api_top_task_id := 0;
1345: Else
1346: select top_task_id into g_api_top_task_id
1347: from pa_tasks where task_id = l_task_id;
1348:
1349: g_api_task_id := l_task_id;
1350: End if;
1351: End If;

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

1693:
1694: -- # Determine entry level code if its 'M'.
1695: If p_entry_level_code = 'M' then
1696: -- task_id being passed is that on pa_resource_assignments ...
1697: -- top task id is determined from pa_tasks
1698: If p_task_id = p_top_task_id then
1699: l_budget_entry_level_code := 'T';
1700: Else
1701: l_budget_entry_level_code := 'L';

Line 2772: FROM pa_tasks

2768: WHERE resource_list_member_id = p_rs_id;
2769: CURSOR get_task_name
2770: (p_task_id IN number) IS
2771: SELECT task_name
2772: FROM pa_tasks
2773: WHERE task_id = p_task_id;
2774: CURSOR get_project_name
2775: (p_project_id IN number) IS
2776: SELECT segment1