86: CURSOR csr_org_req (c_ext_dfn_id IN NUMBER
87: ,c_ext_rslt_id IN NUMBER
88: ,c_business_group_id IN NUMBER) IS
89: SELECT bba.request_id
90: FROM ben_benefit_actions bba
91: WHERE bba.pl_id = c_ext_rslt_id
92: AND bba.pgm_id = c_ext_dfn_id
93: AND bba.business_group_id = c_business_group_id;
94:
3325:
3326: CURSOR csr_jcl_org_req (c_ext_dfn_id IN NUMBER
3327: ,c_ext_rslt_id IN NUMBER ) IS
3328: SELECT bba.request_id
3329: FROM ben_benefit_actions bba
3330: WHERE bba.pl_id = c_ext_rslt_id
3331: AND bba.pgm_id = c_ext_dfn_id ;
3332:
3333: CURSOR csr_jcl_req_params( c_req_id IN NUMBER) IS