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.JL_JLARPCWT_XMLP_PKG dependencies on JG_ZZ_ENTITY_ASSOC

Line 301: JG_ZZ_ENTITY_ASSOC JGEA_C

297: SELECT
298: JGEA_C.ID_NUMBER
299: INTO L_COMPANY_NUM_AGENT_RET
300: FROM
301: JG_ZZ_ENTITY_ASSOC JGEA_C
302: WHERE JGEA_C.PRIMARY_ID_NUMBER = COMP_PRIMARY_ID_NUMBER
303: AND JGEA_C.ASSOCIATED_ENTITY_ID = COMP_TAX_AUTHORITY_ID
304: AND JGEA_C.ID_TYPE = COMP_TAX_AUTHORITY_TYPE;
305: RETURN (L_COMPANY_NUM_AGENT_RET);

Line 335: JG_ZZ_ENTITY_ASSOC JGEA_S

331: SELECT
332: JGEA_S.ID_NUMBER SUPPLIER_PROVINCE_NUMBER
333: INTO L_SUPPLIER_PROVINCE_NUMBER
334: FROM
335: JG_ZZ_ENTITY_ASSOC JGEA_S
336: WHERE JGEA_S.PRIMARY_ID_NUMBER = SUPP_PRIMARY_ID_NUMBER
337: AND JGEA_S.ASSOCIATED_ENTITY_ID = SUPP_TAX_AUTHORITY_ID
338: AND JGEA_S.ID_TYPE = SUPP_TAX_AUTHORITY_TYPE
339: AND WITHHOLDING_DATE between JGEA_S.EFFECTIVE_DATE