APPS.JAI_CMN_REVERSE_CHARGE_PKG dependencies on JAI_RGM_SETTLEMENTS

Line 1563: p_source_table_name => 'JAI_RGM_SETTLEMENTS',

1559: p_organization_type => lv_organization_type,
1560: p_organization_id => r_rec.organization_id,
1561: p_source => jai_constants.source_ap,
1562: p_source_trx_type => 'INVOICE_SETTLEMENT',
1563: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
1564: p_source_document_id => pn_settlement_id,
1565: p_code_combination_id => ln_charge_accounting_id,
1566: p_entered_cr => NULL,
1567: p_entered_dr => ln_recovery_amount,

Line 1597: p_source_table_name => 'JAI_RGM_SETTLEMENTS',

1593: p_organization_type => lv_organization_type,
1594: p_organization_id => r_rec.organization_id,
1595: p_source => jai_constants.source_ap,
1596: p_source_trx_type => 'INVOICE_SETTLEMENT',
1597: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
1598: p_source_document_id => pn_settlement_id,
1599: p_code_combination_id => ln_charge_accounting_id,
1600: p_entered_cr => ln_recovery_amount,
1601: p_entered_dr => NULL,

Line 1707: FROM JAI_RGM_SETTLEMENTS

1703:
1704:
1705: CURSOR get_inv_num_settlement IS
1706: SELECT MANUAL_INVOICE_NO
1707: FROM JAI_RGM_SETTLEMENTS
1708: WHERE settlement_id = p_source_document_id;
1709:
1710: CURSOR get_inv_num_ap IS
1711: SELECT INVOICE_NUM

Line 1844: FROM JAI_RGM_SETTLEMENTS jrs,

1840: ) IS
1841:
1842: CURSOR c_settle IS
1843: SELECT jrs.*
1844: FROM JAI_RGM_SETTLEMENTS jrs,
1845: JAI_RGM_DEFINITIONS jrd
1846: where jrs.regime_id = jrd.regime_id
1847: and jrd.regime_code = jai_constants.service_regime
1848: and jrs.payment_date between p_from_date and p_to_date

Line 1908: AND jrr.source_table_name = 'JAI_RGM_SETTLEMENTS'

1904: Where jrr.reference_id = jrf.reference_id
1905: AND jrf.invoice_id = pn_invoice_id
1906: AND jrr.source = jai_constants.source_ap
1907: AND jrr.source_trx_type = 'INVOICE_SETTLEMENT'
1908: AND jrr.source_table_name = 'JAI_RGM_SETTLEMENTS'
1909: AND jrr.source_document_id = pn_settlement_id
1910: AND jrf.reference_id = pn_reference_id
1911: AND jrf.line_id = pn_invoice_line_id
1912: AND jrf.tax_id = pn_tax_id;

Line 2005: p_source_table_name => 'JAI_RGM_SETTLEMENTS',

2001: p_location_id => r_rec.location_id,
2002: p_service_type_code => lv_service_type_code,
2003: p_source => jai_constants.source_ap,
2004: p_source_trx_type => 'INVOICE_SETTLEMENT',
2005: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
2006: p_source_document_id => r_sel.settlement_id,
2007: p_transaction_date => r_sel.PAYMENT_DATE,
2008: p_account_name => NULL,
2009: p_charge_account_id => NULL,