APPS.JAI_DRILLDOWN_UTILS_PKG dependencies on JAI_RGM_DIS_DES_TAXES

Line 129: jai_rgm_dis_des_taxes jrddt

125: SELECT DISTINCT transfer_number
126: INTO ln_transfer_number
127: FROM jai_rgm_dis_des_hdrs jrddh,
128: jai_rgm_dis_src_taxes jrdst,
129: jai_rgm_dis_des_taxes jrddt
130:
131: WHERE round(jrddt.transfer_amount,2) = pn_balance
132: AND jrddh.transfer_destination_id = jrddt.transfer_destination_id
133: AND jrdst.transfer_source_id = jrddt.transfer_source_id

Line 146: jai_rgm_dis_des_taxes jrddt

142: SELECT DISTINCT transfer_number
143: INTO ln_transfer_number
144: FROM jai_rgm_dis_des_hdrs jrddh,
145: jai_rgm_dis_src_taxes jrdst,
146: jai_rgm_dis_des_taxes jrddt
147:
148: WHERE round(jrddt.transfer_amount,2) = pn_balance
149:
150: AND jrddh.transfer_destination_id = jrddt.transfer_destination_id

Line 218: jai_rgm_dis_des_taxes jrddt,

214: SELECT DISTINCT organization_name
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

Line 289: jai_rgm_dis_des_taxes jrddt

285: INTO lv_des_org_type
286: FROM ja_lookups ja,
287: jai_rgm_dis_des_hdrs jrddh,
288: jai_rgm_dis_src_taxes jrdst,
289: jai_rgm_dis_des_taxes jrddt
290:
291: WHERE ja.lookup_type = 'JAI_ORGANIZATION_TYPES'
292: AND ja.lookup_code = jrddh.destination_party_type
293:

Line 307: jai_rgm_dis_des_taxes jrddt

303: INTO lv_des_org_type
304: FROM ja_lookups ja,
305: jai_rgm_dis_des_hdrs jrddh,
306: jai_rgm_dis_src_taxes jrdst,
307: jai_rgm_dis_des_taxes jrddt
308:
309: WHERE ja.lookup_type = 'JAI_ORGANIZATION_TYPES'
310: AND ja.lookup_code = jrddh.destination_party_type
311:

Line 376: jai_rgm_dis_des_taxes jrddt

372: INTO lv_des_loc_name
373: FROM hr_locations hr,
374: jai_rgm_dis_des_hdrs jrddh,
375: jai_rgm_dis_src_taxes jrdst,
376: jai_rgm_dis_des_taxes jrddt
377:
378: WHERE hr.location_id(+) = jrddh.location_id
379: AND round(jrddt.transfer_amount,2) = pn_balance
380: AND jrdst.transfer_source_id = jrddt.transfer_source_id

Line 392: jai_rgm_dis_des_taxes jrddt

388: INTO lv_des_loc_name
389: FROM hr_locations hr,
390: jai_rgm_dis_des_hdrs jrddh,
391: jai_rgm_dis_src_taxes jrdst,
392: jai_rgm_dis_des_taxes jrddt
393:
394: WHERE hr.location_id(+) = jrddh.location_id
395: AND round(jrddt.transfer_amount,2) = pn_balance
396: AND jrdst.transfer_source_id = jrddt.transfer_source_id