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_PROCESSING_PKG dependencies on JAI_ST_INVOICE_REVERSAL

Line 958: FROM jai_st_invoice_reversal jsir

954: pn_organization_id IN NUMBER) IS
955:
956: CURSOR get_claim_trxn_cur IS
957: SELECT jsir.*
958: FROM jai_st_invoice_reversal jsir
959: WHERE jsir.source = 'AP'
960: --Add by Chong for bug#13259755, start
961: AND jsir.organization_id = pn_organization_id
962: --Add by Chong for bug#13259755, end

Line 1044: UPDATE jai_st_invoice_reversal

1040:
1041: END LOOP;
1042:
1043: IF nvl(ln_max_payment_id, 0) > nvl(reversal_trxn_rec.max_claim_payment_id, 0) THEN
1044: UPDATE jai_st_invoice_reversal
1045: SET max_claim_payment_id = ln_max_payment_id
1046: WHERE invoice_id = reversal_trxn_rec.invoice_id
1047: AND line_num = reversal_trxn_rec.line_num
1048: AND SOURCE = 'AP';

Line 4805: FROM jai_st_invoice_reversal jsir

4801: GROUP BY invoice_id;
4802:
4803: CURSOR get_claim_trxn_cur IS
4804: SELECT jsir.*
4805: FROM jai_st_invoice_reversal jsir
4806: WHERE jsir.source = 'AP'
4807: --Add by Chong for bug#13259755 on 27-OCT-2011 start
4808: AND jsir.organization_id = p_organization_id
4809: --Add by Chong for bug#13259755 on 27-OCT-2011 end

Line 4815: FROM jai_st_invoice_reversal jsir

4811: ORDER BY jsir.invoice_id;
4812:
4813: CURSOR get_reversal_trxn_cur IS
4814: SELECT jsir.*
4815: FROM jai_st_invoice_reversal jsir
4816: WHERE jsir.source = 'AP'
4817: AND jsir.date_of_reversal BETWEEN p_from_date AND p_to_date;
4818:
4819: CURSOR get_claim_amt_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER, pn_max_payment_id IN NUMBER) IS