DBA Data[Home] [Help]

APPS.JAI_DRILLDOWN_UTILS_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 204: FROM org_organization_definitions

200: WHERE transfer_id = pn_transfer_id;
201:
202: CURSOR get_des_org_name_cur(pn_id IN NUMBER) IS
203: SELECT organization_name
204: FROM org_organization_definitions
205: WHERE organization_id = pn_id;
206:
207: BEGIN
208:

Line 219: org_organization_definitions ood

215: INTO ln_des_org_name
216: FROM jai_rgm_dis_des_hdrs jrddh,
217: jai_rgm_dis_src_taxes jrdst,
218: jai_rgm_dis_des_taxes jrddt,
219: org_organization_definitions ood
220:
221: WHERE round(jrddt.transfer_amount,2) = pn_balance
222: AND jrddh.destination_party_id = ood.organization_id
223: AND jrdst.transfer_source_id = jrddt.transfer_source_id