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_RGM_THHOLD_PROC_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 872: from JAI_CMN_CUS_ADDRESSES

868:
869: cursor c_get_cust_typ_lkup_code
870: is
871: select tcs_customer_type
872: from JAI_CMN_CUS_ADDRESSES
873: where customer_id = p_party_id
874: AND tcs_customer_type IS NOT NULL; --added the AND condition for bug#6156619
875:
876:

Line 1514: cursor c_get_customer_pan (cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)

1510: from jai_rgm_threshold_dtls
1511: where threshold_id = cp_threshold_id
1512: and item_classification = cp_item_classification;
1513:
1514: cursor c_get_customer_pan (cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)
1515: is
1516: select pan_no
1517: from JAI_CMN_CUS_ADDRESSES
1518: where customer_id = cp_customer_id

Line 1517: from JAI_CMN_CUS_ADDRESSES

1513:
1514: cursor c_get_customer_pan (cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)
1515: is
1516: select pan_no
1517: from JAI_CMN_CUS_ADDRESSES
1518: where customer_id = cp_customer_id
1519: and confirm_pan = jai_constants.yes;
1520:
1521: cursor c_get_ref_thhold_base_amt (cp_base_tax_type jai_rgm_taxes.tax_type%type)