APPS.PA_ASSET_ALLOCATION_PVT dependencies on PA_PROJECT_ASSETS_ALL

Line 25: FROM pa_project_assets_all

21: CURSOR all_project_assets_cur(x_line_type VARCHAR2) IS
22: SELECT project_asset_id,
23: 0, --asset_basis_amount
24: 0 --total_basis_amount
25: FROM pa_project_assets_all
26: WHERE project_id = p_project_id
27: AND capital_event_id = p_capital_event_id
28: AND project_asset_type = DECODE(x_line_type,'C','AS-BUILT','R','RETIREMENT_ADJUSTMENT','AS-BUILT')
29: AND nvl(asset_category_id, -99) = nvl(p_asset_category_id, nvl(asset_category_id, -99)) /* Bug#3211946 */

Line 37: FROM pa_project_assets_all pa,

33: CURSOR project_asgn_assets_cur(x_line_type VARCHAR2) IS
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

Line 53: FROM pa_project_assets_all pa,

49: CURSOR task_asgn_assets_cur(x_task_id NUMBER, x_line_type VARCHAR2) IS
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

Line 71: FROM pa_project_assets_all pa,

67: CURSOR top_task_asgn_assets_cur(x_line_type VARCHAR2) IS
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

Line 108: v_project_asset_type PA_PROJECT_ASSETS_ALL.project_asset_type%TYPE;

104: v_msg_count NUMBER := 0;
105: v_msg_data VARCHAR2(2000);
106: v_asset_count NUMBER := 0;
107: v_project_asset_id NUMBER;
108: v_project_asset_type PA_PROJECT_ASSETS_ALL.project_asset_type%TYPE;
109: v_date_placed_in_service DATE;
110: v_capital_hold_flag PA_PROJECT_ASSETS_ALL.capital_hold_flag%TYPE;
111: v_total_basis_amount NUMBER := 0;
112: v_asset_basis_amount NUMBER := 0;

Line 110: v_capital_hold_flag PA_PROJECT_ASSETS_ALL.capital_hold_flag%TYPE;

106: v_asset_count NUMBER := 0;
107: v_project_asset_id NUMBER;
108: v_project_asset_type PA_PROJECT_ASSETS_ALL.project_asset_type%TYPE;
109: v_date_placed_in_service DATE;
110: v_capital_hold_flag PA_PROJECT_ASSETS_ALL.capital_hold_flag%TYPE;
111: v_total_basis_amount NUMBER := 0;
112: v_asset_basis_amount NUMBER := 0;
113: v_init_total_basis_amount NUMBER := 0;
114: v_sum_asset_basis_amount NUMBER := 0;

Line 479: FROM pa_project_assets_all pa

475: WHILE i IS NOT NULL LOOP
476:
477: SELECT COUNT(*)
478: INTO v_asset_count
479: FROM pa_project_assets_all pa
480: WHERE pa.project_id = p_project_id
481: AND pa.project_asset_id = asset_basis_table(i).PROJECT_ASSET_ID;
482:
483: IF v_asset_count = 0 THEN

Line 496: FROM pa_project_assets_all pa

492: capital_hold_flag
493: INTO v_project_asset_type,
494: v_date_placed_in_service,
495: v_capital_hold_flag
496: FROM pa_project_assets_all pa
497: WHERE pa.project_id = p_project_id
498: AND pa.project_asset_id = asset_basis_table(i).PROJECT_ASSET_ID;
499:
500: --Verify that the DPIS is NOT NULL

Line 627: FROM pa_project_assets_all

623:
624: --For Actual Units method, Asset Basis Amount = Actual Units
625: SELECT asset_units
626: INTO v_asset_basis_amount
627: FROM pa_project_assets_all
628: WHERE project_asset_id = asset_basis_table(i).PROJECT_ASSET_ID;
629:
630: asset_basis_table(i).ASSET_BASIS_AMOUNT := v_asset_basis_amount;
631:

Line 663: FROM pa_project_assets_all

659: v_asset_basis_amount := NULL; --Initialize this to NULL in order to trap NULL units as an error
660:
661: SELECT grouped_cip_cost
662: INTO v_asset_basis_amount
663: FROM pa_project_assets_all
664: WHERE project_asset_id = asset_basis_table(i).PROJECT_ASSET_ID;
665:
666: asset_basis_table(i).ASSET_BASIS_AMOUNT := v_asset_basis_amount;
667:

Line 700: FROM pa_project_assets_all

696: v_asset_basis_amount := NULL; --Initialize this to NULL in order to trap NULL units as an error
697:
698: SELECT estimated_cost
699: INTO v_asset_basis_amount
700: FROM pa_project_assets_all
701: WHERE project_asset_id = asset_basis_table(i).PROJECT_ASSET_ID;
702:
703: asset_basis_table(i).ASSET_BASIS_AMOUNT := v_asset_basis_amount;
704:

Line 742: FROM pa_project_assets_all

738: NVL(book_type_code,'X')
739: INTO v_asset_units,
740: v_asset_category_id,
741: v_book_type_code
742: FROM pa_project_assets_all
743: WHERE project_asset_id = asset_basis_table(i).PROJECT_ASSET_ID;
744:
745: SELECT COUNT(*)
746: INTO v_std_cost_count