APPS.IGP_VW_GEN_002_PKG dependencies on HZ_PARTIES

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

136: CURSOR c_port_info(cp_port_ids IN NUMBER) IS
137: SELECT ''||(RPAD(NVL(port.portfolio_name, nbsp), 80))||'' name,
138: ''||(RPAD(NVL(DECODE(port.pub_end_date,to_date('31/12/4172','dd/mm/yyyy'),NULL,port.pub_end_date),nbsp), 13))||'' pub_end_date,
139: ''||(RPAD(NVL((hz.person_last_name||','||hz.person_first_name),nbsp), 360))||'' AUTHOR
140: FROM igp_us_portfolios port, igp_ac_accounts acc, hz_parties hz
141: WHERE port.account_id = acc.account_id AND
142: acc.party_id = hz.party_id AND
143: port.portfolio_id = cp_port_ids ;
144: rec_port_info c_port_info%ROWTYPE;

Line 324: FROM hz_parties hz, fnd_user us, igp_ac_accounts ac

320: l_error_message VARCHAR2(500);
321:
322: CURSOR c_viewer_info(cp_viewer_id IN NUMBER) IS
323: SELECT (hz.person_last_name||','||hz.person_first_name) VIEWER , us.user_name
324: FROM hz_parties hz, fnd_user us, igp_ac_accounts ac
325: WHERE ac.party_id = hz.party_id AND
326: us.user_id=ac.user_id AND
327: hz.party_id = cp_viewer_id;
328:

Line 333: FROM hz_parties hz,fnd_user fu

329: -- Get the details of CC name.
330: CURSOR c_get_CC_name(cp_CC_user_name VARCHAR2)
331: IS
332: SELECT (hz.person_last_name||','||hz.person_first_name) CC_NAME
333: FROM hz_parties hz,fnd_user fu
334: WHERE fu.person_party_id=hz.party_id
335: AND fu.user_name = cp_CC_user_name;
336:
337: rec_viewer_info c_viewer_info%ROWTYPE;

Line 338: l_cc_name hz_parties.party_name%TYPE;

334: WHERE fu.person_party_id=hz.party_id
335: AND fu.user_name = cp_CC_user_name;
336:
337: rec_viewer_info c_viewer_info%ROWTYPE;
338: l_cc_name hz_parties.party_name%TYPE;
339:
340: BEGIN
341:
342: l_seq_val_vw := 'IGPVW2CC'||to_char(SYSDATE,'YYYYMMDDHH24MISS');

Line 432: l_viewer_id hz_parties.party_id%TYPE;

428: l_end_pos NUMBER(10);
429: l_cur_pos NUMBER(10);
430: l_count NUMBER(10);
431: l_viewer_ids VARCHAR2(32000);
432: l_viewer_id hz_parties.party_id%TYPE;
433: l_portfolio_ids VARCHAR2(32000);
434: l_basic_text VARCHAR2(32000);
435:
436: nbsp VARCHAR2(10);

Line 447: FROM hz_parties hz, fnd_user us, igp_ac_accounts ac

443: port.portfolio_id = cp_port_ids;
444:
445: CURSOR c_viewer_info(cp_viewer_id IN NUMBER) IS
446: SELECT (hz.person_last_name||','||hz.person_first_name) VIEWER , us.user_name,us.email_address
447: FROM hz_parties hz, fnd_user us, igp_ac_accounts ac
448: WHERE ac.party_id = hz.party_id AND
449: us.user_id=ac.user_id AND
450: hz.party_id = cp_viewer_id;
451:

Line 456: FROM hz_parties hz,fnd_user fu

452: -- Get the details of CC name.
453: CURSOR c_get_CC_name(cp_CC_user_name VARCHAR2)
454: IS
455: SELECT (hz.person_last_name||','||hz.person_first_name) CC_NAME
456: FROM hz_parties hz,fnd_user fu
457: WHERE fu.person_party_id=hz.party_id
458: AND fu.user_name = cp_CC_user_name;
459:
460:

Line 465: l_cc_name hz_parties.party_name%TYPE;

461: rec_viewer_info c_viewer_info%ROWTYPE;
462: rec_port_info c_port_info%ROWTYPE;
463: l_stmt varchar2(32000);
464: l_port_id NUMBER(15);
465: l_cc_name hz_parties.party_name%TYPE;
466:
467: BEGIN
468:
469: l_seq_val_au := 'IGPVW2AU'||to_char(SYSDATE,'YYYYMMDDHH24MISS');

Line 704: FROM hz_parties

700: WHERE portfolio_id=to_number(cp_port_id);
701: -- Get the name of the viewer.
702: CURSOR c_get_viewer_name(cp_party_id VARCHAR2) IS
703: SELECT person_last_name||', '||person_first_name
704: FROM hz_parties
705: WHERE party_id=to_number(cp_party_id);
706:
707: l_str varchar2(2000);
708: l_length number;