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.ZX_EXTRACT_PKG dependencies on XLE_LEGALAUTH_V

Line 2227: l_legal_auth_address_line2 xle_legalauth_v.address2%TYPE;

2223: l_activity_code xle_firstparty_information_v.activity_code%TYPE;
2224: l_sub_activity_code xle_firstparty_information_v.activity_code%TYPE;
2225: l_inception_date DATE;
2226: l_legal_contact_party_num xle_legal_contacts_v.contact_legal_id%TYPE;
2227: l_legal_auth_address_line2 xle_legalauth_v.address2%TYPE;
2228: l_legal_auth_address_line3 xle_legalauth_v.address3%TYPE;
2229: l_legal_auth_city xle_legalauth_v.city%TYPE;
2230: l_legal_auth_name xle_legalauth_v.authority_name%TYPE;
2231: l_org_information2 VARCHAR2(150);

Line 2228: l_legal_auth_address_line3 xle_legalauth_v.address3%TYPE;

2224: l_sub_activity_code xle_firstparty_information_v.activity_code%TYPE;
2225: l_inception_date DATE;
2226: l_legal_contact_party_num xle_legal_contacts_v.contact_legal_id%TYPE;
2227: l_legal_auth_address_line2 xle_legalauth_v.address2%TYPE;
2228: l_legal_auth_address_line3 xle_legalauth_v.address3%TYPE;
2229: l_legal_auth_city xle_legalauth_v.city%TYPE;
2230: l_legal_auth_name xle_legalauth_v.authority_name%TYPE;
2231: l_org_information2 VARCHAR2(150);
2232: l_program_application_id NUMBER;

Line 2229: l_legal_auth_city xle_legalauth_v.city%TYPE;

2225: l_inception_date DATE;
2226: l_legal_contact_party_num xle_legal_contacts_v.contact_legal_id%TYPE;
2227: l_legal_auth_address_line2 xle_legalauth_v.address2%TYPE;
2228: l_legal_auth_address_line3 xle_legalauth_v.address3%TYPE;
2229: l_legal_auth_city xle_legalauth_v.city%TYPE;
2230: l_legal_auth_name xle_legalauth_v.authority_name%TYPE;
2231: l_org_information2 VARCHAR2(150);
2232: l_program_application_id NUMBER;
2233: l_program_id NUMBER;

Line 2230: l_legal_auth_name xle_legalauth_v.authority_name%TYPE;

2226: l_legal_contact_party_num xle_legal_contacts_v.contact_legal_id%TYPE;
2227: l_legal_auth_address_line2 xle_legalauth_v.address2%TYPE;
2228: l_legal_auth_address_line3 xle_legalauth_v.address3%TYPE;
2229: l_legal_auth_city xle_legalauth_v.city%TYPE;
2230: l_legal_auth_name xle_legalauth_v.authority_name%TYPE;
2231: l_org_information2 VARCHAR2(150);
2232: l_program_application_id NUMBER;
2233: l_program_id NUMBER;
2234: l_program_login_id NUMBER;

Line 2292: FROM xle_legalauth_v xle_auth,

2288: SELECT xle_auth.address2,
2289: xle_auth.address3,
2290: xle_auth.city,
2291: xle_auth.authority_name
2292: FROM xle_legalauth_v xle_auth,
2293: xle_registrations xle_reg
2294: WHERE xle_reg.source_id = c_rep_entity_id
2295: AND xle_reg.source_table = 'XLE_ENTITY_PROFILES'
2296: AND xle_auth.legalauth_id = xle_reg.issuing_authority_id