APPS.PQP_ERG_BUS dependencies on PER_BUSINESS_GROUPS

Line 28: from per_business_groups pbg

24: -- Declare cursor
25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pqp_exception_report_groups erg
30: , pqp_exception_reports exr
31: where erg.exception_group_id = p_exception_group_id
32: and pbg.business_group_id = exr.business_group_id

Line 90: from per_business_groups pbg

86: -- Declare cursor
87: --
88: cursor csr_leg_code is
89: select pbg.legislation_code
90: from per_business_groups pbg
91: , pqp_exception_report_groups erg
92: , pqp_exception_reports exr
93: where erg.exception_group_id = p_exception_group_id
94: and exr.exception_report_id = erg.exception_report_id

Line 549: FROM per_business_groups pbg where pbg.business_group_id=p_business_group_id;

545: legislation_code = p_legislation_code)
546: ;
547: cursor c2 is
548: SELECT pbg.legislation_code
549: FROM per_business_groups pbg where pbg.business_group_id=p_business_group_id;
550: --
551: Begin
552: hr_utility.set_location('Entering:'||l_proc, 5);
553: --

Line 628: FROM per_business_groups pbg where pbg.business_group_id=p_business_group_id;

624: and business_group_id = p_business_group_id)
625: );
626: cursor c2 is
627: SELECT pbg.legislation_code
628: FROM per_business_groups pbg where pbg.business_group_id=p_business_group_id;
629:
630: --
631: Begin
632: