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 418: jai_rgm_Settlements jrs

414: FROM jai_rgm_stl_balances stl
415: WHERE settlement_id =
416: (SELECT MAX(jstl.settlement_id)
417: FROM jai_rgm_stl_balances jstl,
418: jai_rgm_Settlements jrs
419: WHERE
420: jstl.party_id = cp_org_id /* 8671217 ,12706846*/
421: AND jstl.location_id = cp_location_id /* 8671217 ,12706846*/
422: AND jstl.settlement_id = jrs.settlement_id

Line 483: FROM JAI_RGM_SETTLEMENTS stL

479:
480: cursor check_org_settled(cp_regime_id in number,cp_org_id in number,cp_location_id in number)
481: is
482: select '1'
483: FROM JAI_RGM_SETTLEMENTS stL
484: WHERE settlement_id =
485: (SELECT MAX(jstl.settlement_id)
486: FROM jai_rgm_stl_balances jstl,
487: jai_rgm_Settlements jrs

Line 487: jai_rgm_Settlements jrs

483: FROM JAI_RGM_SETTLEMENTS stL
484: WHERE settlement_id =
485: (SELECT MAX(jstl.settlement_id)
486: FROM jai_rgm_stl_balances jstl,
487: jai_rgm_Settlements jrs
488: WHERE
489: jstl.party_id = cp_org_id /* 8671217 ,12706846*/
490: AND jstl.location_id = cp_location_id /* 8671217 ,12706846*/
491: AND jstl.settlement_id = jrs.settlement_id

Line 921: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl

917: FROM jai_rgm_trx_records
918: WHERE regime_primary_regno = p_regn_no
919: AND source_trx_type = 'Invoice Payment'
920: AND settlement_id = ( SELECT MAX(jbal.settlement_id)
921: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl
922: WHERE jbal.settlement_id = jstl.settlement_id
923: AND jstl.primary_registration_no = p_regn_no
924: AND jbal.party_type = p_org_type
925: AND jbal.party_id = p_org_id

Line 949: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl

945: WHERE source_trx_type = 'Invoice Payment'
946: -- AND service_type_code = nvl(cp_service_type_code,service_type_code)/*added nvl for bug#13865856*/
947: and (cp_service_type_code is null or service_type_code =cp_service_type_code) /*Commented the above and added the condition for bug 14475128 */
948: AND settlement_id = ( SELECT MAX(jbal.settlement_id)
949: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl
950: WHERE jbal.settlement_id = jstl.settlement_id
951: AND jbal.party_type = cp_org_type
952: AND jbal.party_id = cp_org_id
953: AND jbal.location_id = nvl(cp_location_id,jbal.location_id)/*5694855*/

Line 976: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl

972: FROM jai_rgm_trx_records
973: WHERE /*regime_primary_regno = p_regn_no*/ -- Commented, Harshita for Bug 5694855
974: source_trx_type = 'Invoice Payment'
975: AND settlement_id = ( SELECT MAX(jbal.settlement_id)
976: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl
977: WHERE jbal.settlement_id = jstl.settlement_id
978: AND jbal.party_type = cp_org_type
979: AND jbal.party_id = cp_org_id
980: AND jbal.tax_type = cp_tax_type

Line 993: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl

989: SELECT sum(credit_balance) credit_balance,sum(debit_balance) debit_balance,jrs.settlement_id,jrs.tax_type,jrs.location_id
990: FROM jai_rgm_stl_balances jrs,
991: (
992: SELECT MAX(jbal.settlement_id) settlement_id,tax_type
993: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl
994: WHERE jbal.settlement_id = jstl.settlement_id
995: AND jstl.primary_registration_no = p_regn_no
996: AND jbal.party_type = p_org_type
997: AND jbal.party_id = p_org_id

Line 1011: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl

1007: CURSOR cur_last_settlement_id
1008: /* added this cursor for bug 7606212 by vumaasha */
1009: IS
1010: SELECT MAX(jbal.settlement_id)
1011: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl
1012: WHERE jbal.settlement_id = jstl.settlement_id
1013: AND jstl.primary_registration_no = p_regn_no
1014: AND jbal.party_type = p_org_type
1015: AND jbal.party_id = p_org_id

Line 1036: jai_rgm_settlements jstl,

1032: WHERE regime_primary_regno = p_regn_no
1033: AND source_trx_type = 'Invoice Payment'
1034: AND settlement_id = ( SELECT MAX(jbal.settlement_id)
1035: FROM jai_rgm_stl_balances jbal,
1036: jai_rgm_settlements jstl,
1037: jai_rgm_definitions jrg
1038: WHERE jbal.settlement_id = jstl.settlement_id
1039: AND jrg.regime_id = jstl.regime_id
1040: AND jrg.regime_code = 'VAT'

Line 1063: jai_rgm_settlements jstl,

1059: SELECT sum(credit_balance) credit_balance,sum(debit_balance) debit_balance,jrs.settlement_id,jrs.tax_type,jrs.location_id
1060: FROM jai_rgm_stl_balances jrs,
1061: ( SELECT MAX(jbal.settlement_id) settlement_id,tax_type
1062: FROM jai_rgm_stl_balances jbal,
1063: jai_rgm_settlements jstl,
1064: JAI_RGM_DEFINITIONS jrg
1065: WHERE jbal.settlement_id = jstl.settlement_id
1066: AND jrg.regime_id = jstl.regime_id
1067: AND jrg.regime_code = 'VAT'

Line 1082: jai_rgm_settlements

1078: --bug#12706846
1079: cursor c_last_settlement_dtls(cp_stl_id in number)
1080: is
1081: select * from
1082: jai_rgm_settlements
1083: where settlement_id=cp_stl_id;
1084:
1085: r_last_settlement_dtls c_last_settlement_dtls%rowtype;
1086:

Line 1095: jai_rgm_settlements jstl,

1091: IS
1092: /* added this cursor for bug 7606212 by vumaasha */
1093: SELECT MAX(jbal.settlement_id)
1094: FROM jai_rgm_stl_balances jbal,
1095: jai_rgm_settlements jstl,
1096: JAI_RGM_DEFINITIONS jrg
1097: WHERE jbal.settlement_id = jstl.settlement_id
1098: AND jrg.regime_id = jstl.regime_id
1099: AND jrg.regime_code = 'VAT'

Line 1157: jai_rgm_settlements jstl

1153: AND location_id = cp_location_id
1154: AND tax_type = cp_tax_type
1155: AND settlement_id = (SELECT MAX(jbal.settlement_id)
1156: FROM JAI_RGM_STL_BALANCES jbal,
1157: jai_rgm_settlements jstl
1158: WHERE jbal.settlement_id = jstl.settlement_id
1159: AND jstl.regime_id = cp_regime_id
1160: AND party_id = cp_org_id
1161: AND location_id = cp_location_id

Line 1760: jai_rgm_settlements jstl,

1756: FROM jai_rgm_stl_balances jrs,
1757: (SELECT MAX(jbal.settlement_id) settlement_id,
1758: tax_type
1759: FROM jai_rgm_stl_balances jbal,
1760: jai_rgm_settlements jstl,
1761: jai_rgm_definitions jrg
1762: WHERE jbal.settlement_id = jstl.settlement_id
1763: AND jrg.regime_id = jstl.regime_id
1764: AND jrg.regime_code = 'TCS'

Line 1781: jai_rgm_settlements jstl,

1777:
1778: CURSOR cur_last_settlement_id_tcs(cp_organization_type VARCHAR2, cp_organization_id NUMBER, cp_location_id NUMBER) IS
1779: SELECT MAX(jbal.settlement_id)
1780: FROM jai_rgm_stl_balances jbal,
1781: jai_rgm_settlements jstl,
1782: jai_rgm_definitions jrg
1783: WHERE jbal.settlement_id = jstl.settlement_id
1784: AND jrg.regime_id = jstl.regime_id
1785: AND jrg.regime_code = 'TCS'

Line 1800: jai_rgm_settlements jstl,

1796: --AND source_document_type = 'Invoice Payment' --mmurtuza need to discuss
1797: AND settlement_id =
1798: (SELECT MAX(jbal.settlement_id)
1799: FROM jai_rgm_stl_balances jbal,
1800: jai_rgm_settlements jstl,
1801: jai_rgm_definitions jrg
1802: WHERE jbal.settlement_id = jstl.settlement_id
1803: AND jrg.regime_id = jstl.regime_id
1804: AND jrg.regime_code = 'TCS'

Line 1814: FROM jai_rgm_settlements

1810: ;
1811:
1812: CURSOR c_last_settlement_dtls(cp_stl_id IN NUMBER) IS
1813: SELECT *
1814: FROM jai_rgm_settlements
1815: WHERE settlement_id = cp_stl_id;
1816:
1817: CURSOR c_get_organization_type(cp_organization_id NUMBER) IS
1818: SELECT DISTINCT organization_type