APPS.JE_BE_CSSR_PKG dependencies on HZ_PARTIES

Line 41: l_tel_num hz_parties.primary_phone_number%TYPE;

37:
38: l_survey_code varchar2(50);
39: l_proc_status varchar2(200);
40: l_legal_entity_name xle_registrations.registered_name%TYPE;
41: l_tel_num hz_parties.primary_phone_number%TYPE;
42: l_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%TYPE;
43: l_dummy varchar2(100);
44: l_exc_survey_code_null exception;
45: l_exc_lang_limit exception;

Line 491: hz_parties parties ,

487: FROM
488: RA_CUST_TRX_LINE_GL_DIST_ALL gld ,
489: ra_customer_trx_all trx ,
490: HZ_CUST_ACCOUNTS hz_cust ,
491: hz_parties parties ,
492: hz_party_sites hz_ps ,
493: hz_locations hzl ,
494: hz_cust_site_uses_all hz_csu ,
495: hz_cust_acct_sites_all hz_cas ,

Line 580: hz_parties parties ,

576: FROM
577: RA_CUST_TRX_LINE_GL_DIST_ALL gld ,
578: ra_customer_trx_all trx ,
579: HZ_CUST_ACCOUNTS hz_cust ,
580: hz_parties parties ,
581: hz_party_sites hz_ps ,
582: hz_locations hzl ,
583: hz_cust_site_uses_all hz_csu ,
584: hz_cust_acct_sites_all hz_cas ,

Line 669: hz_parties parties,

665: ra_customer_trx_all trx ,
666: hz_cust_accounts hz_cust,
667: hz_cust_site_uses_all hz_csu,
668: hz_cust_acct_sites_all hz_cas,
669: hz_parties parties,
670: hz_party_sites hz_ps,
671: hz_locations hzl,
672: fnd_lookup_values lv,
673: gl_ledgers glr