APPS.ZPB_AC_OPS dependencies on FND_LOOKUP_VALUES_VL

Line 1071: ( SELECT tag FROM fnd_lookup_values_vl WHERE lookup_type = 'ZPB_PARAMS' AND

1067: BEGIN
1068: IF (p_start_mem IS NOT NULL ) THEN
1069: UPDATE zpb_ac_param_values SET value = p_start_mem WHERE
1070: analysis_cycle_id = new_ac_id AND param_id =
1071: ( SELECT tag FROM fnd_lookup_values_vl WHERE lookup_type = 'ZPB_PARAMS' AND
1072: lookup_code = 'CAL_HS_TIME_MEMBER');
1073: END IF;
1074:
1075: IF (p_end_mem IS NOT NULL ) THEN

Line 1078: ( SELECT tag FROM fnd_lookup_values_vl WHERE lookup_type = 'ZPB_PARAMS' AND

1074:
1075: IF (p_end_mem IS NOT NULL ) THEN
1076: UPDATE zpb_ac_param_values SET value = p_end_mem WHERE
1077: analysis_cycle_id = new_ac_id AND param_id =
1078: ( SELECT tag FROM fnd_lookup_values_vl WHERE lookup_type = 'ZPB_PARAMS' AND
1079: lookup_code = 'CAL_HE_TIME_MEMBER');
1080: END IF;
1081: END updateHorizonParams;
1082: --BPEXT

Line 1580: FROM fnd_lookup_values_vl

1576: FROM zpb_analysis_cycles
1577: WHERE analysis_cycle_id = new_ac_id;
1578:
1579: SELECT tag INTO l_appview_param_id
1580: FROM fnd_lookup_values_vl
1581: WHERE LOOKUP_CODE = 'APPEND_VIEW'
1582: and LOOKUP_TYPE = 'ZPB_PARAMS';
1583:
1584: UPDATE zpb_analysis_cycles

Line 3628: FROM fnd_lookup_values_vl

3624: FROM ZPB_AC_PARAM_VALUES
3625: WHERE analysis_cycle_id = p_ac_id_in
3626: AND param_id =
3627: (SELECT tag
3628: FROM fnd_lookup_values_vl
3629: WHERE LOOKUP_TYPE = 'ZPB_PARAMS'
3630: AND LOOKUP_CODE = 'APPEND_VIEW');
3631:
3632: IF (l_param_value= 'APPEND_VIEW')