APPS.IGP_VW_GEN_002_PKG dependencies on IGP_US_PORTFOLIOS

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 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 699: FROM igp_us_portfolios

695: IS
696: -- Get the details of portfolio.
697: CURSOR c_get_port_name(cp_port_id VARCHAR2) IS
698: SELECT portfolio_name
699: FROM igp_us_portfolios
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