DBA Data[Home] [Help]

APPS.JAI_RETRO_PRC_PKG dependencies on JAI_RGM_DEFINITIONS

Line 447: JAI_RGM_DEFINITIONS jr

443: jai_retro_tax_changes jrtc
444: WHERE EXISTS( SELECT
445: 'X'
446: FROM
447: JAI_RGM_DEFINITIONS jr
448: , JAI_RGM_REGISTRATIONS jrr
449: WHERE jr.regime_id = jrr.regime_id
450: AND jr.regime_code = jai_constants.vat_regime
451: AND jrr.registration_type = jai_constants.regn_type_tax_types

Line 1840: JAI_RGM_DEFINITIONS jr

1836: jai_retro_tax_changes jrtc
1837: WHERE EXISTS ( SELECT
1838: 'X'
1839: FROM
1840: JAI_RGM_DEFINITIONS jr
1841: , JAI_RGM_REGISTRATIONS jrr
1842: WHERE jr.regime_id = jrr.regime_id
1843: AND jr.regime_code = jai_constants.vat_regime
1844: AND jrr.registration_type = jai_constants.regn_type_tax_types

Line 1872: , jai_rgm_definitions jrd

1868: , jrl.receipt_num
1869: , jrd.regime_id
1870: FROM
1871: jai_rcv_rgm_lines jrrl
1872: , jai_rgm_definitions jrd
1873: , jai_rcv_lines jrl
1874: WHERE jrrl.rcv_rgm_line_id = pn_rcv_rgm_line_id
1875: AND jrrl.shipment_line_id = jrl.shipment_line_id
1876: AND jrrl.regime_code = jrd.regime_code;