APPS.IGP_VW_GEN_002_PKG dependencies on IGP_AC_ACCOUNTS

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 440: FROM igp_us_portfolios port, igp_ac_accounts acc, fnd_user fnd

436: nbsp VARCHAR2(10);
437:
438: CURSOR c_port_info(cp_port_ids IN NUMBER) IS
439: SELECT port.portfolio_name, fnd.user_name
440: FROM igp_us_portfolios port, igp_ac_accounts acc, fnd_user fnd
441: WHERE port.account_id = acc.account_id AND
442: fnd.user_id = acc.user_id AND
443: port.portfolio_id = cp_port_ids;
444:

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: