APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on JAI_RGM_DEFINITIONS

Line 629: cursor c_jai_regimes (cpv_regime_code jai_rgm_definitions.regime_code%type) is /* added by vumaasha for bug 8238608 */

625: from JAI_RCV_TRANSACTIONS
626: where shipment_header_id = p_shipment_header_id
627: and third_party_flag in ('N', 'X'); -- for bug 14172169 by anupgupt
628:
629: cursor c_jai_regimes (cpv_regime_code jai_rgm_definitions.regime_code%type) is /* added by vumaasha for bug 8238608 */
630: select regime_id
631: from jai_rgm_definitions
632: where regime_code = cpv_regime_code;
633:

Line 631: from jai_rgm_definitions

627: and third_party_flag in ('N', 'X'); -- for bug 14172169 by anupgupt
628:
629: cursor c_jai_regimes (cpv_regime_code jai_rgm_definitions.regime_code%type) is /* added by vumaasha for bug 8238608 */
630: select regime_id
631: from jai_rgm_definitions
632: where regime_code = cpv_regime_code;
633:
634: cursor c_trx_dtls(cp_transaction_id rcv_transactions.transaction_id%TYPE) is /* added by vumaasha for bug 8238608 */
635: SELECT rt.po_distribution_id,

Line 694: ln_regime_id jai_rgm_definitions.regime_id%TYPE; /* added by vumaasha for bug 8238608 */

690: lv_orig_currcy_conver_type rcv_transactions.currency_conversion_type%type; --added by eric for inclusive tax on 20-dec-2007
691: lv_orig_currcy_conver_rate rcv_transactions.currency_conversion_rate%type; --added by eric for inclusive tax on 20-dec-2007
692: lv_orig_currcy_conver_date date; --added by eric for inclusive tax on 20-dec-2007
693: r_trx_dtls c_trx_dtls%ROWTYPE; /* added by vumaasha for bug 8238608 */
694: ln_regime_id jai_rgm_definitions.regime_id%TYPE; /* added by vumaasha for bug 8238608 */
695: ln_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE; /* added by vumaasha for bug 8238608 */
696:
697: --added the below cursor for bug#6988610 by eric on Apr 24,2008 ,begin
698: -----------------------------------------------------------------------