DBA Data[Home] [Help]

APPS.JAI_DRILLDOWN_UTILS_PKG dependencies on JAI_RGM_DIS_SRC_HDRS

Line 114: FROM jai_rgm_dis_src_hdrs

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:

Line 199: FROM jai_rgm_dis_src_hdrs

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

Line 274: FROM jai_rgm_dis_src_hdrs

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:

Line 361: FROM jai_rgm_dis_src_hdrs

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: