APPS.PQP_UTILITIES dependencies on PQP_CONFIGURATION_VALUES

Line 89: FROM pqp_configuration_values pcv, pqp_configuration_types pct

85: ,pcv.pcv_information14, pcv.pcv_information15
86: ,pcv.pcv_information16, pcv.pcv_information17
87: ,pcv.pcv_information18, pcv.pcv_information19
88: ,pcv.pcv_information20
89: FROM pqp_configuration_values pcv, pqp_configuration_types pct
90: WHERE pcv.pcv_information_category = pct.configuration_type
91: AND pct.configuration_type = p_configuration_type
92: AND ( ( pcv.business_group_id IS NOT NULL
93: AND pcv.business_group_id = p_business_group_id

Line 99: FROM pqp_configuration_values pcv2

95: OR ( pcv.legislation_code IS NOT NULL
96: AND pcv.legislation_code = c_legislation_code
97: AND NOT EXISTS(
98: SELECT 1
99: FROM pqp_configuration_values pcv2
100: WHERE pcv2.pcv_information_category =
101: pcv.pcv_information_category
102: AND pcv2.configuration_value_id <>
103: pcv.configuration_value_id

Line 246: FROM pqp_configuration_values pcv3

242: OR ( pcv.business_group_id IS NULL
243: AND pcv.legislation_code IS NULL
244: AND NOT EXISTS(
245: SELECT 1
246: FROM pqp_configuration_values pcv3
247: WHERE pcv3.pcv_information_category =
248: pcv.pcv_information_category
249: AND pcv3.configuration_value_id <>
250: pcv.configuration_value_id

Line 3051: -- the PQP_CONFIGURATION_VALUES table.These values are used to round off the

3047: END round_value_up_down ;
3048: --
3049: --
3050: -- This funcaion is used to fecth the values for the rounding off factors from
3051: -- the PQP_CONFIGURATION_VALUES table.These values are used to round off the
3052: -- absences days and entitlments remaining days.
3053: FUNCTION pqp_get_config_value(
3054: p_business_group_id IN NUMBER
3055: ,p_legislation_code IN VARCHAR2

Line 3068: FROM pqp_configuration_values

3064: l_temp_str VARCHAR2(1000);
3065: BEGIN
3066:
3067: l_temp_str := 'SELECT '|| p_column_name ||'
3068: FROM pqp_configuration_values
3069: WHERE ((business_group_id = ' ||p_business_group_id ||'
3070: AND legislation_code IS NULL )
3071: OR (business_group_id IS NULL
3072: AND legislation_code =

Line 3085: -- no rows are present in pqp_configuration_values for the information

3081: FETCH c_column_cursor INTO l_column_value;
3082: CLOSE c_column_cursor;
3083:
3084: -- Assign default values to avoid erroring of absence processing in case
3085: -- no rows are present in pqp_configuration_values for the information
3086: -- category PQP_GB_OSP_OMP_ROUND.
3087:
3088: /* IF (l_column_value IS NULL) AND (p_column_name='PCV_INFORMATION1' OR p_column_name='PCV_INFORMATION3') THEN
3089: l_column_value:='DOWN';