110: ln_source_org_id NUMBER;
111:
112: CURSOR get_source_org_id_cur IS
113: SELECT party_id
114: FROM jai_rgm_dis_src_hdrs
115: WHERE transfer_id = pn_transfer_id;
116:
117: BEGIN
118:
195: ln_des_org_name VARCHAR2(80);
196:
197: CURSOR get_source_org_id_cur IS
198: SELECT party_id
199: FROM jai_rgm_dis_src_hdrs
200: WHERE transfer_id = pn_transfer_id;
201:
202: CURSOR get_des_org_name_cur(pn_id IN NUMBER) IS
203: SELECT organization_name
270: ln_source_org_id NUMBER;
271:
272: CURSOR get_source_org_id_cur IS
273: SELECT party_id
274: FROM jai_rgm_dis_src_hdrs
275: WHERE transfer_id = pn_transfer_id;
276:
277: BEGIN
278:
357: ln_source_org_id NUMBER;
358:
359: CURSOR get_source_org_id_cur IS
360: SELECT party_id
361: FROM jai_rgm_dis_src_hdrs
362: WHERE transfer_id = pn_transfer_id;
363:
364: BEGIN
365: