APPS.PQH_CEI_BUS dependencies on PER_BUSINESS_GROUPS

Line 414: -- pqh_corps_extra_info and PER_BUSINESS_GROUPS

410: --
411: -- Declare cursor
412: --
413: -- EDIT_HERE In the following cursor statement add join(s) between
414: -- pqh_corps_extra_info and PER_BUSINESS_GROUPS
415: -- so that the security_group_id for
416: -- the current business group context can be derived.
417: -- Remove this comment when the edit has been completed.
418: cursor csr_sec_grp is

Line 420: from per_business_groups pbg

416: -- the current business group context can be derived.
417: -- Remove this comment when the edit has been completed.
418: cursor csr_sec_grp is
419: select pbg.security_group_id
420: from per_business_groups pbg
421: , pqh_corps_extra_info cei
422: -- , EDIT_HERE table_name(s) 333
423: where cei.corps_extra_info_id = p_corps_extra_info_id;
424: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 484: -- pqh_corps_extra_info and PER_BUSINESS_GROUPS

480: --
481: -- Declare cursor
482: --
483: -- EDIT_HERE In the following cursor statement add join(s) between
484: -- pqh_corps_extra_info and PER_BUSINESS_GROUPS
485: -- so that the legislation_code for
486: -- the current business group context can be derived.
487: -- Remove this comment when the edit has been completed.
488: cursor csr_leg_code is

Line 490: from per_business_groups pbg

486: -- the current business group context can be derived.
487: -- Remove this comment when the edit has been completed.
488: cursor csr_leg_code is
489: select pbg.legislation_code
490: from per_business_groups pbg
491: , pqh_corps_extra_info cei
492: -- , EDIT_HERE table_name(s) 333
493: where cei.corps_extra_info_id = p_corps_extra_info_id;
494: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;