eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_RGM_SETTLEMENTS

Line 508: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl

504: WHERE regime_primary_regno = p_regn_no
505: AND source_trx_type = 'Invoice Payment'
506: AND service_type_code = cp_service_type_code /*Added by nprashar for bug # 6359082*/
507: AND settlement_id = ( SELECT MAX(jbal.settlement_id)
508: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl
509: WHERE jbal.settlement_id = jstl.settlement_id
510: AND jstl.primary_registration_no = p_regn_no
511: AND jbal.party_type = p_org_type
512: AND jbal.party_id = p_org_id

Line 535: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl

531: FROM jai_rgm_trx_records
532: WHERE source_trx_type = 'Invoice Payment'
533: AND service_type_code = cp_service_type_code
534: AND settlement_id = ( SELECT MAX(jbal.settlement_id)
535: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl
536: WHERE jbal.settlement_id = jstl.settlement_id
537: AND jbal.party_type = cp_org_type
538: AND jbal.party_id = cp_org_id
539: AND jbal.location_id = nvl(cp_location_id,jbal.location_id)/*5694855*/

Line 561: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl

557: FROM jai_rgm_trx_records
558: WHERE /*regime_primary_regno = p_regn_no*/ -- Commented, Harshita for Bug 5694855
559: source_trx_type = 'Invoice Payment'
560: AND settlement_id = ( SELECT MAX(jbal.settlement_id)
561: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl
562: WHERE jbal.settlement_id = jstl.settlement_id
563: AND jbal.party_type = cp_org_type
564: AND jbal.party_id = cp_org_id
565: AND jbal.tax_type = cp_tax_type

Line 577: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl

573: */
574: SELECT sum(credit_balance) credit_balance,sum(debit_balance) debit_balance
575: FROM jai_rgm_stl_balances
576: WHERE settlement_id = ( SELECT MAX(jbal.settlement_id)
577: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl
578: WHERE jbal.settlement_id = jstl.settlement_id
579: AND jstl.primary_registration_no = p_regn_no
580: AND jbal.party_type = p_org_type
581: AND jbal.party_id = p_org_id

Line 605: jai_rgm_settlements jstl,

601: WHERE regime_primary_regno = p_regn_no
602: AND source_trx_type = 'Invoice Payment'
603: AND settlement_id = ( SELECT MAX(jbal.settlement_id)
604: FROM jai_rgm_stl_balances jbal,
605: jai_rgm_settlements jstl,
606: jai_rgm_definitions jrg
607: WHERE jbal.settlement_id = jstl.settlement_id
608: AND jrg.regime_id = jstl.regime_id
609: AND jrg.regime_code = 'VAT'

Line 631: jai_rgm_settlements jstl,

627: SELECT sum(credit_balance) credit_balance,sum(debit_balance) debit_balance
628: FROM jai_rgm_stl_balances
629: WHERE settlement_id = ( SELECT MAX(jbal.settlement_id)
630: FROM jai_rgm_stl_balances jbal,
631: jai_rgm_settlements jstl,
632: jai_rgm_definitions jrg
633: WHERE jbal.settlement_id = jstl.settlement_id
634: AND jrg.regime_id = jstl.regime_id
635: AND jrg.regime_code = 'VAT'