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 5910: from pa_lookups

5906: -- Cursor used in validating the product code
5907: Cursor p_product_code_csr (c_pm_product_code IN VARCHAR2)
5908: Is
5909: Select 'X'
5910: from pa_lookups
5911: where lookup_type='PM_PRODUCT_CODE'
5912: and lookup_code = c_pm_product_code;
5913:
5914: -- Bug 3986129: FP.M Web ADI Dev changes

Line 5917: l_etc_method_code pa_lookups.lookup_code%TYPE;

5913:
5914: -- Bug 3986129: FP.M Web ADI Dev changes
5915: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
5916: l_valid_spread_curve VARCHAR2(1) := 'Y';
5917: l_etc_method_code pa_lookups.lookup_code%TYPE;
5918: l_valid_etc_method VARCHAR2(1) := 'Y';
5919: l_mfc_cost_type_id CST_COST_TYPES_V.cost_type_id%TYPE;
5920: l_valid_mfc_cost_type VARCHAR2(1) := 'Y';
5921:

Line 5924: l_new_error_code pa_lookups.lookup_code%TYPE;

5920: l_valid_mfc_cost_type VARCHAR2(1) := 'Y';
5921:
5922: l_webadi_sp_fix_date DATE;
5923: l_webadi_err_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5924: l_new_error_code pa_lookups.lookup_code%TYPE;
5925: l_webadi_err_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5926: l_webadi_err_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5927: l_webadi_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5928: l_webadi_err_amt_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 7375: FROM pa_lookups

7371: p_etc_method_name_tbl(i) <> FND_API.G_MISS_CHAR) THEN
7372: BEGIN
7373: SELECT lookup_code
7374: INTO l_etc_method_code
7375: FROM pa_lookups
7376: WHERE lookup_type = 'PA_FP_ETC_METHOD'
7377: AND meaning = p_etc_method_name_tbl(i);
7378: EXCEPTION
7379: WHEN NO_DATA_FOUND THEN