116: --
117: cursor c1 is
118: select null
119: from hr_all_organization_units org,
120: ben_popl_org_f pop
121: where org.organization_id = p_organization_id
122: and pop.organization_id = org.organization_id
123: and pop.pl_id = p_pl_id
124: and p_effective_date between
131: --
132: cursor c2 is
133: select null
134: from hr_all_organization_units org,
135: ben_popl_org_f pop,
136: ben_oipl_f cop
137: where org.organization_id = p_organization_id
138: and pop.organization_id = org.organization_id
139: and cop.oipl_id = p_oipl_id