APPS.PA_ASSET_ALLOCATION_PVT dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 38: pa_project_asset_assignments paa

34: SELECT paa.project_asset_id,
35: 0, --asset_basis_amount
36: 0 --total_basis_amount
37: FROM pa_project_assets_all pa,
38: pa_project_asset_assignments paa
39: WHERE pa.project_asset_id = paa.project_asset_id
40: AND pa.project_id = p_project_id
41: AND paa.project_id = p_project_id
42: AND pa.capital_event_id = p_capital_event_id

Line 54: pa_project_asset_assignments paa

50: SELECT paa.project_asset_id,
51: 0, --asset_basis_amount
52: 0 --total_basis_amount
53: FROM pa_project_assets_all pa,
54: pa_project_asset_assignments paa
55: WHERE pa.project_asset_id = paa.project_asset_id
56: AND pa.project_id = p_project_id
57: AND paa.project_id = p_project_id
58: AND pa.capital_event_id = p_capital_event_id

Line 72: pa_project_asset_assignments paa

68: SELECT paa.project_asset_id,
69: 0, --asset_basis_amount
70: 0 --total_basis_amount
71: FROM pa_project_assets_all pa,
72: pa_project_asset_assignments paa
73: WHERE pa.project_asset_id = paa.project_asset_id
74: AND pa.project_id = p_project_id
75: AND paa.project_id = p_project_id
76: AND pa.capital_event_id = p_capital_event_id

Line 209: FROM pa_project_asset_assignments

205:
206: --Determine if entire project has a 'Common' Asset Assignment
207: SELECT DECODE(COUNT(*),0,'N','Y')
208: INTO v_common_project
209: FROM pa_project_asset_assignments
210: WHERE project_id = p_project_id
211: AND task_id = 0
212: AND project_asset_id = 0;
213:

Line 239: FROM pa_project_asset_assignments

235: --('Common' Asset Assignments at the Top Task level are allocated across
236: --ALL project assets, just like Project-level Common assignments)
237: SELECT DECODE(COUNT(*),0,'N','Y')
238: INTO v_common_task
239: FROM pa_project_asset_assignments
240: WHERE project_id = p_project_id
241: AND task_id = v_top_task_id
242: AND project_asset_id = 0;
243:

Line 248: FROM pa_project_asset_assignments

244: IF v_common_task = 'N' THEN
245: --Determine if the current task has a Lowest Task Common assignment
246: SELECT DECODE(COUNT(*),0,'N','Y')
247: INTO v_common_lowest_task
248: FROM pa_project_asset_assignments
249: WHERE project_id = p_project_id
250: AND task_id = p_task_id
251: AND task_id <> v_top_task_id --Only Lowest "Leaf" Tasks that are not also Top Tasks
252: AND project_asset_id = 0;

Line 320: FROM pa_project_asset_assignments paa

316:
317: --Check for a project level grouping method
318: SELECT COUNT(*)
319: INTO v_assignment_count
320: FROM pa_project_asset_assignments paa
321: WHERE paa.project_id = p_project_id
322: AND paa.task_id = 0;
323:
324:

Line 351: FROM pa_project_asset_assignments paa

347:
348: --Check for a task level grouping method
349: SELECT COUNT(*)
350: INTO v_assignment_count
351: FROM pa_project_asset_assignments paa
352: WHERE paa.project_id = p_project_id
353: AND paa.task_id = p_task_id;
354:
355: IF v_assignment_count > 0 THEN

Line 380: FROM pa_project_asset_assignments paa

376: END IF;
377:
378: SELECT COUNT(*)
379: INTO v_assignment_count
380: FROM pa_project_asset_assignments paa
381: WHERE paa.project_id = p_project_id
382: AND paa.task_id = v_top_task_id;
383:
384: IF v_assignment_count > 0 THEN