[Home] [Help]
23: --
24: -- Declare cursor
25: --
26: -- EDIT_HERE In the following cursor statement add join(s) between
27: -- hr_organization_information and PER_BUSINESS_GROUPS
28: -- so that the security_group_id for
29: -- the current business group context can be derived.
30: -- Remove this comment when the edit has been completed.
31: cursor csr_sec_grp is
29: -- the current business group context can be derived.
30: -- Remove this comment when the edit has been completed.
31: cursor csr_sec_grp is
32: select pbg.security_group_id
33: from per_business_groups pbg
34: , hr_organization_information ori
35: -- , EDIT_HERE table_name(s) 333
36: where ori.org_information_id = p_org_information_id;
37: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
811: --
812: -- Declare cursor
813: --
814: -- EDIT_HERE In the following cursor statement add join(s) between
815: -- hr_organization_information and PER_BUSINESS_GROUPS
816: -- so that the legislation_code for
817: -- the current business group context can be derived.
818: -- Remove this comment when the edit has been completed.
819: -- JOIN COMPLETED
818: -- Remove this comment when the edit has been completed.
819: -- JOIN COMPLETED
820: /*cursor csr_leg_code is
821: select pbg.legislation_code
822: from per_business_groups pbg
823: , hr_organization_information ori
824: , hr_all_organization_units org -- Modified for bug # 6794638 to pick from base table
825: where ori.org_information_id = p_org_information_id
826: and org.organization_id = ori.organization_id
1617: -- select statement above
1618: --
1619: -- AND hoit.legislation_code =
1620: -- (SELECT pbg.legislation_code
1621: -- FROM per_business_groups pbg
1622: -- ,hr_all_organization_units haou
1623: -- WHERE haou.organization_id = p_organization_id
1624: -- AND haou.business_group_id = pbg.business_group_id)
1625: --