193: WHERE srp_id = P_MGR_SRP_ID;
194:
195:
196:
197: l_srp_tbl cn_srp_hier_proc_pvt.group_mbr_tbl_type;
198: l_srp_rec cn_srp_hier_proc_pvt.srp_group_rec_type;
199: l_returned_rows number;
200: l_return_status VARCHAR2(1);
201:
194:
195:
196:
197: l_srp_tbl cn_srp_hier_proc_pvt.group_mbr_tbl_type;
198: l_srp_rec cn_srp_hier_proc_pvt.srp_group_rec_type;
199: l_returned_rows number;
200: l_return_status VARCHAR2(1);
201:
202:
225: l_srp_rec.group_id := p_comp_group_id;
226: l_srp_rec.effective_date := p_period_id;
227:
228:
229: cn_srp_hier_proc_pvt.Get_Descendant_group_mbrs
230: (p_api_version => 1.0,
231: p_init_msg_list => FND_API.G_FALSE,
232: p_commit => FND_API.G_FALSE,
233: p_validation_level => FND_API.G_VALID_LEVEL_FULL,