73: CURSOR csr_org_req (c_ext_dfn_id IN NUMBER
74: ,c_ext_rslt_id IN NUMBER
75: ,c_business_group_id IN NUMBER) IS
76: SELECT bba.request_id
77: FROM ben_benefit_actions bba
78: WHERE bba.pl_id = c_ext_rslt_id
79: AND bba.pgm_id = c_ext_dfn_id
80: AND bba.business_group_id = c_business_group_id;
81:
200: ,ben.benefit_action_id
201: ,ben.business_group_id
202: ,ben.process_date
203: ,ben.request_id
204: FROM ben_benefit_actions ben
205: WHERE ben.pl_id = c_ext_rslt_id
206: AND ben.pgm_id = c_ext_dfn_id
207: AND ben.business_group_id = c_business_group_id;
208:
6694:
6695: CURSOR csr_jcl_org_req (c_ext_dfn_id IN NUMBER
6696: ,c_ext_rslt_id IN NUMBER ) IS
6697: SELECT bba.request_id
6698: FROM ben_benefit_actions bba
6699: WHERE bba.pl_id = c_ext_rslt_id
6700: AND bba.pgm_id = c_ext_dfn_id ;
6701:
6702: