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 2688: l_legal_auth_address_line2 xle_legalauth_v.address2%TYPE;

2684: l_activity_code xle_firstparty_information_v.activity_code%TYPE;
2685: l_sub_activity_code xle_firstparty_information_v.activity_code%TYPE;
2686: l_inception_date DATE;
2687: l_legal_contact_party_num xle_legal_contacts_v.contact_legal_id%TYPE;
2688: l_legal_auth_address_line2 xle_legalauth_v.address2%TYPE;
2689: l_legal_auth_address_line3 xle_legalauth_v.address3%TYPE;
2690: l_legal_auth_city xle_legalauth_v.city%TYPE;
2691: l_legal_auth_name xle_legalauth_v.authority_name%TYPE;
2692: l_org_information2 VARCHAR2(150);

Line 2689: l_legal_auth_address_line3 xle_legalauth_v.address3%TYPE;

2685: l_sub_activity_code xle_firstparty_information_v.activity_code%TYPE;
2686: l_inception_date DATE;
2687: l_legal_contact_party_num xle_legal_contacts_v.contact_legal_id%TYPE;
2688: l_legal_auth_address_line2 xle_legalauth_v.address2%TYPE;
2689: l_legal_auth_address_line3 xle_legalauth_v.address3%TYPE;
2690: l_legal_auth_city xle_legalauth_v.city%TYPE;
2691: l_legal_auth_name xle_legalauth_v.authority_name%TYPE;
2692: l_org_information2 VARCHAR2(150);
2693: l_program_application_id NUMBER;

Line 2690: l_legal_auth_city xle_legalauth_v.city%TYPE;

2686: l_inception_date DATE;
2687: l_legal_contact_party_num xle_legal_contacts_v.contact_legal_id%TYPE;
2688: l_legal_auth_address_line2 xle_legalauth_v.address2%TYPE;
2689: l_legal_auth_address_line3 xle_legalauth_v.address3%TYPE;
2690: l_legal_auth_city xle_legalauth_v.city%TYPE;
2691: l_legal_auth_name xle_legalauth_v.authority_name%TYPE;
2692: l_org_information2 VARCHAR2(150);
2693: l_program_application_id NUMBER;
2694: l_program_id NUMBER;

Line 2691: l_legal_auth_name xle_legalauth_v.authority_name%TYPE;

2687: l_legal_contact_party_num xle_legal_contacts_v.contact_legal_id%TYPE;
2688: l_legal_auth_address_line2 xle_legalauth_v.address2%TYPE;
2689: l_legal_auth_address_line3 xle_legalauth_v.address3%TYPE;
2690: l_legal_auth_city xle_legalauth_v.city%TYPE;
2691: l_legal_auth_name xle_legalauth_v.authority_name%TYPE;
2692: l_org_information2 VARCHAR2(150);
2693: l_program_application_id NUMBER;
2694: l_program_id NUMBER;
2695: l_program_login_id NUMBER;

Line 2753: FROM xle_legalauth_v xle_auth,

2749: SELECT xle_auth.address2,
2750: xle_auth.address3,
2751: xle_auth.city,
2752: xle_auth.authority_name
2753: FROM xle_legalauth_v xle_auth,
2754: xle_registrations xle_reg
2755: WHERE xle_reg.source_id = c_rep_entity_id
2756: AND xle_reg.source_table = 'XLE_ENTITY_PROFILES'
2757: AND xle_auth.legalauth_id = xle_reg.issuing_authority_id