DBA Data[Home] [Help]

APPS.PQP_PCV_BUS dependencies on PER_BUSINESS_GROUPS_PERF

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 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;