APPS.PA_BUDGET_PVT dependencies on PA_LOOKUPS

Line 27: FROM pa_lookups

23: -- Cursor to validate the change reason code
24: CURSOR l_budget_change_reason_csr ( c_change_reason_code VARCHAR2 )
25: IS
26: SELECT 'x'
27: FROM pa_lookups
28: WHERE lookup_type = 'BUDGET CHANGE REASON'
29: AND lookup_code = c_change_reason_code;
30:
31: --Bug 2871603: Added the following PLSQL table to remove build dependency.

Line 360: from pa_lookups

356: -- Cursor used in validating the product code
357: Cursor p_product_code_csr (c_pm_product_code IN VARCHAR2)
358: Is
359: Select 'X'
360: from pa_lookups
361: where lookup_type='PM_PRODUCT_CODE'
362: and lookup_code = c_pm_product_code;
363:
364:

Line 2782: from pa_lookups

2778: -- Cursor used in validating the product code
2779: Cursor p_product_code_csr (c_pm_product_code IN VARCHAR2)
2780: Is
2781: Select 'X'
2782: from pa_lookups
2783: where lookup_type='PM_PRODUCT_CODE'
2784: and lookup_code = c_pm_product_code;
2785:
2786: -- needed to get the related budget_version, entry_method and resource_list

Line 5927: from pa_lookups

5923: -- Cursor used in validating the product code
5924: Cursor p_product_code_csr (c_pm_product_code IN VARCHAR2)
5925: Is
5926: Select 'X'
5927: from pa_lookups
5928: where lookup_type='PM_PRODUCT_CODE'
5929: and lookup_code = c_pm_product_code;
5930:
5931: -- Bug 3986129: FP.M Web ADI Dev changes

Line 5934: l_etc_method_code pa_lookups.lookup_code%TYPE;

5930:
5931: -- Bug 3986129: FP.M Web ADI Dev changes
5932: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
5933: l_valid_spread_curve VARCHAR2(1) := 'Y';
5934: l_etc_method_code pa_lookups.lookup_code%TYPE;
5935: l_valid_etc_method VARCHAR2(1) := 'Y';
5936: l_mfc_cost_type_id CST_COST_TYPES_V.cost_type_id%TYPE;
5937: l_valid_mfc_cost_type VARCHAR2(1) := 'Y';
5938:

Line 5941: l_new_error_code pa_lookups.lookup_code%TYPE;

5937: l_valid_mfc_cost_type VARCHAR2(1) := 'Y';
5938:
5939: l_webadi_sp_fix_date DATE;
5940: l_webadi_err_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5941: l_new_error_code pa_lookups.lookup_code%TYPE;
5942: l_webadi_err_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5943: l_webadi_err_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5944: l_webadi_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5945: l_webadi_err_amt_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 7452: FROM pa_lookups

7448: p_etc_method_name_tbl(i) <> FND_API.G_MISS_CHAR) THEN
7449: BEGIN
7450: SELECT lookup_code
7451: INTO l_etc_method_code
7452: FROM pa_lookups
7453: WHERE lookup_type = 'PA_FP_ETC_METHOD'
7454: AND meaning = p_etc_method_name_tbl(i);
7455: EXCEPTION
7456: WHEN NO_DATA_FOUND THEN