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 780: from JAI_CMN_CUS_ADDRESSES

776:
777: cursor c_get_cust_typ_lkup_code
778: is
779: select tcs_customer_type
780: from JAI_CMN_CUS_ADDRESSES
781: where customer_id = p_party_id
782: AND tcs_customer_type IS NOT NULL; --added the AND condition for bug#6156619
783:
784:

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

1411: from jai_rgm_threshold_dtls
1412: where threshold_id = cp_threshold_id
1413: and item_classification = cp_item_classification;
1414:
1415: cursor c_get_customer_pan (cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)
1416: is
1417: select pan_no
1418: from JAI_CMN_CUS_ADDRESSES
1419: where customer_id = cp_customer_id

Line 1418: from JAI_CMN_CUS_ADDRESSES

1414:
1415: cursor c_get_customer_pan (cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)
1416: is
1417: select pan_no
1418: from JAI_CMN_CUS_ADDRESSES
1419: where customer_id = cp_customer_id
1420: and confirm_pan = jai_constants.yes;
1421:
1422: cursor c_get_ref_thhold_base_amt (cp_base_tax_type jai_rgm_taxes.tax_type%type)