DBA Data[Home] [Help]

APPS.JAI_RETRO_PRC_PKG dependencies on JAI_RGM_DEFINITIONS

Line 442: JAI_RGM_DEFINITIONS jr

438: jai_retro_tax_changes jrtc
439: WHERE EXISTS( SELECT
440: 'X'
441: FROM
442: JAI_RGM_DEFINITIONS jr
443: , JAI_RGM_REGISTRATIONS jrr
444: WHERE jr.regime_id = jrr.regime_id
445: AND jr.regime_code = jai_constants.vat_regime
446: AND jrr.registration_type = jai_constants.regn_type_tax_types

Line 1835: JAI_RGM_DEFINITIONS jr

1831: jai_retro_tax_changes jrtc
1832: WHERE EXISTS ( SELECT
1833: 'X'
1834: FROM
1835: JAI_RGM_DEFINITIONS jr
1836: , JAI_RGM_REGISTRATIONS jrr
1837: WHERE jr.regime_id = jrr.regime_id
1838: AND jr.regime_code = jai_constants.vat_regime
1839: AND jrr.registration_type = jai_constants.regn_type_tax_types

Line 1867: , jai_rgm_definitions jrd

1863: , jrl.receipt_num
1864: , jrd.regime_id
1865: FROM
1866: jai_rcv_rgm_lines jrrl
1867: , jai_rgm_definitions jrd
1868: , jai_rcv_lines jrl
1869: WHERE jrrl.rcv_rgm_line_id = pn_rcv_rgm_line_id
1870: AND jrrl.shipment_line_id = jrl.shipment_line_id
1871: AND jrrl.regime_code = jrd.regime_code;