APPS.IGP_VW_GEN_001_PKG dependencies on IGP_AC_ACCOUNTS

Line 50: FROM fnd_user fnd, igp_ac_accounts acc

46: l_error_message VARCHAR2(500);
47:
48: CURSOR c_viewer(cp_viewer IN NUMBER) IS
49: SELECT fnd.user_name VIEWER
50: FROM fnd_user fnd, igp_ac_accounts acc
51: WHERE acc.user_id = fnd.user_id AND acc.party_id = cp_viewer;
52:
53: rec_viewer c_viewer%ROWTYPE;
54: l_stmt varchar2(32000);

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 449: igp_ac_accounts acc

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
452: AND acc.user_id = fu.user_id;
453:

Line 551: FROM igp_us_portfolios port, igp_ac_accounts acc, fnd_user fnd

547: nbsp VARCHAR2(10);
548:
549: CURSOR c_port_info(cp_port_ids IN NUMBER) IS
550: SELECT port.portfolio_name, fnd.user_name
551: FROM igp_us_portfolios port, igp_ac_accounts acc, fnd_user fnd
552: WHERE port.account_id = acc.account_id AND
553: fnd.user_id = acc.user_id AND
554: port.portfolio_id = cp_port_ids ;
555: