APPS.PQP_PCV_BUS dependencies on PER_BUSINESS_GROUPS

Line 30: from per_business_groups_perf pbg

26: --
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: --

Line 100: from per_business_groups_perf pbg

96: -- Declare cursor
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: --

Line 537: l_legislation_code per_business_groups.legislation_code%TYPE;

533: FUNCTION get_legislation_code
534: (p_business_group_id IN NUMBER
535: ) RETURN VARCHAR2 IS
536: --declare local variables
537: l_legislation_code per_business_groups.legislation_code%TYPE;
538:
539: CURSOR c_get_leg_code IS
540: SELECT legislation_code
541: FROM per_business_groups_perf

Line 541: FROM per_business_groups_perf

537: l_legislation_code per_business_groups.legislation_code%TYPE;
538:
539: CURSOR c_get_leg_code IS
540: SELECT legislation_code
541: FROM per_business_groups_perf
542: WHERE business_group_id =p_business_group_id;
543:
544: BEGIN
545: OPEN c_get_leg_code;

Line 815: l_legislation_code per_business_groups.legislation_code%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);
814:
815: l_legislation_code per_business_groups.legislation_code%TYPE;
816: l_mult_occurrence pqp_configuration_types.multiple_occurences_flag%TYPE;
817: l_exists NUMBER;
818: l_config_desc pqp_configuration_types.description%TYPE;
819: l_total_uniq_cols NUMBER;