APPS.PQP_PCV_BUS dependencies on PQP_CONFIGURATION_VALUES

Line 31: , pqp_configuration_values pcv

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , pqp_configuration_values pcv
32: where pcv.configuration_value_id = p_configuration_value_id
33: and pbg.business_group_id = pcv.business_group_id;
34: --
35: -- Declare local variables

Line 101: , pqp_configuration_values pcv

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , pqp_configuration_values pcv
102: where pcv.configuration_value_id = p_configuration_value_id
103: and pbg.business_group_id (+) = pcv.business_group_id;
104: --
105: -- Declare local variables

Line 734: FROM pqp_configuration_values

730:
731: IF l_where_clause is not null then
732: hr_utility.set_location('Inside If', 5);
733: l_temp_str := 'SELECT count(CONFIGURATION_VALUE_ID)
734: FROM pqp_configuration_values
735: WHERE NVL(business_group_id,'||''''||hr_api.g_number||''''||') =
736: NVL('||''''||p_rec.business_group_id||''''||','||''''||hr_api.g_number||''''||')
737: AND NVL(legislation_code, '||''''||hr_api.g_varchar2||''''||')=
738: NVL('||''''||p_rec.legislation_code||''''||','||''''||hr_api.g_varchar2||''''||')

Line 809: FROM pqp_configuration_values

805: ,c_legislation_code VARCHAR2
806: )
807: IS
808: SELECT 1
809: FROM pqp_configuration_values
810: WHERE pcv_information_category = c_config_type
811: AND configuration_value_id <> NVL(c_config_val_id, hr_api.g_number)
812: AND NVL(business_group_id, hr_api.g_number) = NVL(c_business_group_id, hr_api.g_number)
813: AND NVL(legislation_code, hr_api.g_varchar2) = NVL(c_legislation_code, hr_api.g_varchar2);

Line 853: -- Check for row existence in pqp_configuration_values

849: IF l_mult_occurrence = 'N' THEN
850:
851: hr_utility.set_location(l_proc, 30);
852:
853: -- Check for row existence in pqp_configuration_values
854: OPEN csr_chk_config_val
855: (p_rec.configuration_value_id
856: ,p_rec.pcv_information_category
857: ,p_rec.business_group_id