APPS.IGP_VW_GEN_001_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 49

SELECT fnd.user_name VIEWER
FROM   fnd_user fnd, igp_ac_accounts acc
WHERE  acc.user_id = fnd.user_id AND acc.party_id = cp_viewer;

Line: 186

SELECT ''||(RPAD(NVL(port.portfolio_name, nbsp), 80))||''   name,
       ''||(RPAD(NVL(NVL(p_expdate,' '),nbsp), 13))||''  pub_end_date,
       ''||(RPAD(NVL((hz.person_last_name||','||hz.person_first_name),nbsp), 360))||''  AUTHOR
FROM   igp_us_portfolios port, igp_ac_accounts acc, hz_parties hz
WHERE  port.account_id = acc.account_id AND
       acc.party_id = hz.party_id AND
       port.portfolio_id = cp_port_ids ;

Line: 372

select igp_ac_bus_events_s.nextval
from dual;

Line: 417

    l_parameter_list_t.delete;

Line: 445

SELECT ''||(RPAD(NVL((hz.person_last_name||','||hz.person_first_name),nbsp), 360))||'' VIEWER,
       ''||fu.email_address||'' EMAIL
FROM   hz_parties hz,
       fnd_user fu,
       igp_ac_accounts acc
WHERE  hz.party_id = cp_viewer
AND    acc.party_id=hz.party_id
AND    acc.user_id = fu.user_id;

Line: 528

select igp_ac_bus_events_s.nextval
from dual;

Line: 550

SELECT port.portfolio_name, fnd.user_name
FROM   igp_us_portfolios port, igp_ac_accounts acc, fnd_user fnd
WHERE  port.account_id = acc.account_id AND
       fnd.user_id = acc.user_id AND
       port.portfolio_id = cp_port_ids ;

Line: 634

   l_parameter_list_t.delete;