APPS.PQP_CONFIG_INFO_PKG dependencies on PQP_CONFIGURATION_VALUES

Line 102: FROM pqp_configuration_values pcv

98: p_business_group_id),35) rates_type
99: ,RPAD(get_element_name(
100: TO_NUMBER(pcv.pcv_information6),
101: p_business_group_id),60) element_name
102: FROM pqp_configuration_values pcv
103: WHERE business_group_id=p_business_group_id;
104:
105: l_configuration_value_id number;
106: l_object_version_number number;

Line 117: FROM pqp_configuration_values pcv

113: IF p_mode='I' THEN
114:
115: SELECT count(*)
116: INTO l_count
117: FROM pqp_configuration_values pcv
118: WHERE pcv.pcv_information_category ='GB_VEHICLE_CALC_INFO'
119: AND pcv.pcv_information1 =p_ownership
120: AND pcv.pcv_information2 =p_usage_type
121: AND pcv.pcv_information3 =p_vehicle_type

Line 150: FROM pqp_configuration_values pcv

146: SELECT configuration_value_id
147: ,object_version_number
148: INTO l_configuration_value_id
149: ,l_object_version_number
150: FROM pqp_configuration_values pcv
151: WHERE pcv.pcv_information_category ='GB_VEHICLE_CALC_INFO'
152: AND pcv.pcv_information1 =p_ownership
153: AND pcv.pcv_information2 =p_usage_type
154: AND pcv.pcv_information3 =p_vehicle_type

Line 182: FROM pqp_configuration_values pcv

178: SELECT configuration_value_id
179: ,object_version_number
180: INTO l_configuration_value_id
181: ,l_object_version_number
182: FROM pqp_configuration_values pcv
183: WHERE pcv.pcv_information_category ='GB_VEHICLE_CALC_INFO'
184: AND pcv.pcv_information1 =p_ownership
185: AND pcv.pcv_information2 =p_usage_type
186: AND pcv.pcv_information3 =p_vehicle_type