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_LEGAL_CONTACTS_V

Line 2676: l_legal_contact_party_name xle_legal_contacts_v.contact_name%TYPE;

2672: l_rep_context_lvl_code VARCHAR2(30);
2673: l_matrix_report_flag VARCHAR2(30);
2674: l_rep_context_entity_region1 VARCHAR2(30);
2675: l_legal_contact_pre_name_adj VARCHAR2(30);
2676: l_legal_contact_party_name xle_legal_contacts_v.contact_name%TYPE;
2677: l_bank_id NUMBER;
2678: l_bank_branch_id NUMBER;
2679: l_bank_account_num NUMBER;
2680: l_taxpayer_id xle_firstparty_information_v.REGISTRATION_NUMBER%TYPE;

Line 2681: l_legal_contact_title xle_legal_contacts_v.title%TYPE;

2677: l_bank_id NUMBER;
2678: l_bank_branch_id NUMBER;
2679: l_bank_account_num NUMBER;
2680: l_taxpayer_id xle_firstparty_information_v.REGISTRATION_NUMBER%TYPE;
2681: l_legal_contact_title xle_legal_contacts_v.title%TYPE;
2682: --l_legal_contact_job_title xle_legal_contacts_v.job_title%TYPE;
2683: l_legal_contact_job_title varchar2(13);--xle_legal_contacts_v.role%TYPE;
2684: l_activity_code xle_firstparty_information_v.activity_code%TYPE;
2685: l_sub_activity_code xle_firstparty_information_v.activity_code%TYPE;

Line 2682: --l_legal_contact_job_title xle_legal_contacts_v.job_title%TYPE;

2678: l_bank_branch_id NUMBER;
2679: l_bank_account_num NUMBER;
2680: l_taxpayer_id xle_firstparty_information_v.REGISTRATION_NUMBER%TYPE;
2681: l_legal_contact_title xle_legal_contacts_v.title%TYPE;
2682: --l_legal_contact_job_title xle_legal_contacts_v.job_title%TYPE;
2683: l_legal_contact_job_title varchar2(13);--xle_legal_contacts_v.role%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;

Line 2683: l_legal_contact_job_title varchar2(13);--xle_legal_contacts_v.role%TYPE;

2679: l_bank_account_num NUMBER;
2680: l_taxpayer_id xle_firstparty_information_v.REGISTRATION_NUMBER%TYPE;
2681: l_legal_contact_title xle_legal_contacts_v.title%TYPE;
2682: --l_legal_contact_job_title xle_legal_contacts_v.job_title%TYPE;
2683: l_legal_contact_job_title varchar2(13);--xle_legal_contacts_v.role%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;

Line 2687: l_legal_contact_party_num xle_legal_contacts_v.contact_legal_id%TYPE;

2683: l_legal_contact_job_title varchar2(13);--xle_legal_contacts_v.role%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;

Line 2744: -- xle_legal_contacts_v xle_cont

2740: -- xle_cont.title,
2741: -- xle_cont.job_title
2742: -- xle_cont.role
2743: FROM xle_firstparty_information_v xle_firstpty
2744: -- xle_legal_contacts_v xle_cont
2745: WHERE xle_firstpty.legal_entity_id = c_rep_entity_id;
2746: -- xle_firstpty.legal_entity_id = xle_cont.entity_id(+)
2747:
2748: CURSOR c_legal_auth_info (c_rep_entity_id number) IS