DBA Data[Home] [Help]

APPS.ZX_EXTRACT_PKG dependencies on XLE_LEGAL_CONTACTS_V

Line 2215: l_legal_contact_party_name xle_legal_contacts_v.contact_name%TYPE;

2211: l_rep_context_lvl_code VARCHAR2(30);
2212: l_matrix_report_flag VARCHAR2(30);
2213: l_rep_context_entity_region1 VARCHAR2(30);
2214: l_legal_contact_pre_name_adj VARCHAR2(30);
2215: l_legal_contact_party_name xle_legal_contacts_v.contact_name%TYPE;
2216: l_bank_id NUMBER;
2217: l_bank_branch_id NUMBER;
2218: l_bank_account_num NUMBER;
2219: l_taxpayer_id xle_firstparty_information_v.REGISTRATION_NUMBER%TYPE;

Line 2220: l_legal_contact_title xle_legal_contacts_v.title%TYPE;

2216: l_bank_id NUMBER;
2217: l_bank_branch_id NUMBER;
2218: l_bank_account_num NUMBER;
2219: l_taxpayer_id xle_firstparty_information_v.REGISTRATION_NUMBER%TYPE;
2220: l_legal_contact_title xle_legal_contacts_v.title%TYPE;
2221: --l_legal_contact_job_title xle_legal_contacts_v.job_title%TYPE;
2222: l_legal_contact_job_title varchar2(13);--xle_legal_contacts_v.role%TYPE;
2223: l_activity_code xle_firstparty_information_v.activity_code%TYPE;
2224: l_sub_activity_code xle_firstparty_information_v.activity_code%TYPE;

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

2217: l_bank_branch_id NUMBER;
2218: l_bank_account_num NUMBER;
2219: l_taxpayer_id xle_firstparty_information_v.REGISTRATION_NUMBER%TYPE;
2220: l_legal_contact_title xle_legal_contacts_v.title%TYPE;
2221: --l_legal_contact_job_title xle_legal_contacts_v.job_title%TYPE;
2222: l_legal_contact_job_title varchar2(13);--xle_legal_contacts_v.role%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;

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

2218: l_bank_account_num NUMBER;
2219: l_taxpayer_id xle_firstparty_information_v.REGISTRATION_NUMBER%TYPE;
2220: l_legal_contact_title xle_legal_contacts_v.title%TYPE;
2221: --l_legal_contact_job_title xle_legal_contacts_v.job_title%TYPE;
2222: l_legal_contact_job_title varchar2(13);--xle_legal_contacts_v.role%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;

Line 2226: l_legal_contact_party_num xle_legal_contacts_v.contact_legal_id%TYPE;

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

Line 2283: -- xle_legal_contacts_v xle_cont

2279: -- xle_cont.title,
2280: -- xle_cont.job_title
2281: -- xle_cont.role
2282: FROM xle_firstparty_information_v xle_firstpty
2283: -- xle_legal_contacts_v xle_cont
2284: WHERE xle_firstpty.legal_entity_id = c_rep_entity_id;
2285: -- xle_firstpty.legal_entity_id = xle_cont.entity_id(+)
2286:
2287: CURSOR c_legal_auth_info (c_rep_entity_id number) IS