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_JLARPWFF_XMLP_PKG dependencies on JG_ZZ_ENTITY_ASSOC

Line 197: JG_ZZ_ENTITY_ASSOC JGEA_C

193: ,13
194: ,' ')
195: INTO L_COMPANY_NUM_AGENT_RET
196: FROM
197: JG_ZZ_ENTITY_ASSOC JGEA_C
198: WHERE JGEA_C.PRIMARY_ID_NUMBER = COMP_PRIMARY_ID_NUMBER
199: AND JGEA_C.ASSOCIATED_ENTITY_ID = COMP_TAX_AUTHORITY_ID
200: AND JGEA_C.ID_TYPE = COMP_TAX_AUTHORITY_TYPE;
201: RETURN (L_COMPANY_NUM_AGENT_RET);

Line 234: JG_ZZ_ENTITY_ASSOC JGEA_S

230: ,13
231: ,' ') SUPPLIER_PROVINCE_NUMBER
232: INTO L_SUPPLIER_PROVINCE_NUMBER
233: FROM
234: JG_ZZ_ENTITY_ASSOC JGEA_S
235: WHERE JGEA_S.PRIMARY_ID_NUMBER = SUPP_PRIMARY_ID_NUMBER
236: AND JGEA_S.ASSOCIATED_ENTITY_ID = SUPP_TAX_AUTHORITY_ID
237: AND JGEA_S.ID_TYPE = SUPP_TAX_AUTHORITY_TYPE;
238: RETURN (L_SUPPLIER_PROVINCE_NUMBER);