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_STL_BALANCES

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 575: FROM jai_rgm_stl_balances

571: || This cursor is used to retrieve the sum of credit and debit balances as on
572: || last settlement date for the given registration number,organization and location grouped at the tax type
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

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 604: FROM jai_rgm_stl_balances jbal,

600: FROM jai_rgm_trx_records
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

Line 628: FROM jai_rgm_stl_balances

624: || last settlement date for the given registration number,organization and location grouped at the tax type
625: || for VAT
626: */
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

Line 630: FROM jai_rgm_stl_balances jbal,

626: */
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

Line 688: cr_balance jai_rgm_stl_balances.credit_balance%type; /added by ssawant for bug 5662296/

684: ln_settled_debit_balance number ;
685: ln_settled_credit_balance number ;
686: -- lv_inv_amount jai_rgm_trx_records.credit_amount%type;/* commented by ssawant for bug 5662296*/
687: ln_invoice_amount jai_rgm_trx_records.credit_amount%type;
688: cr_balance jai_rgm_stl_balances.credit_balance%type; /*added by ssawant for bug 5662296*/
689: dr_balance jai_rgm_stl_balances.debit_balance%type; /*added by ssawant for bug 5662296*/
690: ln_settled_flag NUMBER(1) := 0;/*added by ssawant for bug 5662296*/
691:
692:

Line 689: dr_balance jai_rgm_stl_balances.debit_balance%type; /added by ssawant for bug 5662296/

685: ln_settled_credit_balance number ;
686: -- lv_inv_amount jai_rgm_trx_records.credit_amount%type;/* commented by ssawant for bug 5662296*/
687: ln_invoice_amount jai_rgm_trx_records.credit_amount%type;
688: cr_balance jai_rgm_stl_balances.credit_balance%type; /*added by ssawant for bug 5662296*/
689: dr_balance jai_rgm_stl_balances.debit_balance%type; /*added by ssawant for bug 5662296*/
690: ln_settled_flag NUMBER(1) := 0;/*added by ssawant for bug 5662296*/
691:
692:
693: BEGIN