APPS.ZPB_ACVAL_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 62: from zpb_ac_param_values params, fnd_lookup_values_vl fnd

58: where editable_ac_id = p_analysis_cycle_id;
59:
60: cursor published_currency is
61: select params.value
62: from zpb_ac_param_values params, fnd_lookup_values_vl fnd
63: where params.param_id = fnd.TAG and fnd.LOOKUP_CODE = 'BUSINESS_PROCESS_CURRENCY'
64: and fnd.LOOKUP_TYPE = 'ZPB_PARAMS' and params.analysis_cycle_id = l_pub_ac_id ;
65:
66: cursor editable_currency is

Line 68: from zpb_ac_param_values params, fnd_lookup_values_vl fnd

64: and fnd.LOOKUP_TYPE = 'ZPB_PARAMS' and params.analysis_cycle_id = l_pub_ac_id ;
65:
66: cursor editable_currency is
67: select params.value
68: from zpb_ac_param_values params, fnd_lookup_values_vl fnd
69: where params.param_id = fnd.TAG and fnd.LOOKUP_CODE = 'BUSINESS_PROCESS_CURRENCY'
70: and fnd.LOOKUP_TYPE = 'ZPB_PARAMS' and params.analysis_cycle_id = l_edt_ac_id ;
71:
72:

Line 2986: AND param_id = (select to_number(tag) FROM fnd_lookup_values_vl

2982: ZPB_BP_VALIDATION_RESULTS WHERE BUS_PROC_ID = l_bp_id;
2983:
2984: CURSOR c_override_rt_warn IS SELECT value
2985: FROM zpb_ac_param_values WHERE analysis_cycle_id = l_bp_id
2986: AND param_id = (select to_number(tag) FROM fnd_lookup_values_vl
2987: WHERE LOOKUP_TYPE = 'ZPB_PARAMS'
2988: AND LOOKUP_CODE = 'IGNORE_RT_BP_VAL_WARNINGS');
2989:
2990: l_ignore_warn VARCHAR2(2);