APPS.IGP_VW_GEN_001_PKG dependencies on HZ_PARTIES

Line 41: l_viewer_id hz_parties.party_id%TYPE;

37: l_end_pos NUMBER(10);
38: l_cur_pos NUMBER(10);
39: l_count NUMBER(10);
40: l_viewer_ids VARCHAR2(32000);
41: l_viewer_id hz_parties.party_id%TYPE;
42: l_status VARCHAR2(1) ;
43: l_port_name VARCHAR2(80);
44: l_author VARCHAR2(360);
45: l_pub_end_date VARCHAR2(20);

Line 189: FROM igp_us_portfolios port, igp_ac_accounts acc, hz_parties hz

185: CURSOR c_port_info(cp_port_ids IN NUMBER) IS
186: SELECT ''||(RPAD(NVL(port.portfolio_name, nbsp), 80))||'' name,
187: ''||(RPAD(NVL(NVL(p_expdate,' '),nbsp), 13))||'' pub_end_date,
188: ''||(RPAD(NVL((hz.person_last_name||','||hz.person_first_name),nbsp), 360))||'' AUTHOR
189: FROM igp_us_portfolios port, igp_ac_accounts acc, hz_parties hz
190: WHERE port.account_id = acc.account_id AND
191: acc.party_id = hz.party_id AND
192: port.portfolio_id = cp_port_ids ;
193: rec_port_info c_port_info%ROWTYPE;

Line 439: l_viewer_id hz_parties.party_id%TYPE;

435: l_end_pos NUMBER(10);
436: l_cur_pos NUMBER(10);
437: l_count NUMBER(10);
438: l_viewer_ids VARCHAR2(32000);
439: l_viewer_id hz_parties.party_id%TYPE;
440: l_basic_text VARCHAR2(32000) ;
441:
442: nbsp VARCHAR2(10) ;
443:

Line 447: FROM hz_parties hz,

443:
444: CURSOR c_viewer_info(cp_viewer IN NUMBER) IS
445: SELECT ''||(RPAD(NVL((hz.person_last_name||','||hz.person_first_name),nbsp), 360))||'' VIEWER,
446: ''||fu.email_address||'' EMAIL
447: FROM hz_parties hz,
448: fnd_user fu,
449: igp_ac_accounts acc
450: WHERE hz.party_id = cp_viewer
451: AND acc.party_id=hz.party_id

Line 542: l_viewer_id hz_parties.party_id%TYPE;

538: l_end_pos NUMBER(10);
539: l_cur_pos NUMBER(10);
540: l_count NUMBER(10);
541: l_viewer_ids VARCHAR2(32000);
542: l_viewer_id hz_parties.party_id%TYPE;
543: l_portfolio_ids VARCHAR2(32000);
544: l_basic_text VARCHAR2(32000);
545: l_seq_num number;
546: