1090:
1091:
1092: -- generate new promise detail
1093: CURSOR prd_genid_crs IS
1094: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;
1095: --Begin bug 7237026 17-Nov-2208 barathsr
1096: CURSOR c_org_id (p_del_id number) IS
1097: select org_id
1098: from iex_delinquencies_all
2492: l_org_id number; --Added for bug 7237026 17-Nov-2008 barathsr
2493:
2494: -- generate new promise detail
2495: CURSOR prd_genid_crs IS
2496: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;
2497:
2498: --Begin bug 7237026 17-Nov-2008 barathsr
2499: CURSOR c_org_id (p_del_id number) IS
2500: select org_id