APPS.IGP_VW_GEN_001_PKG dependencies on FND_USER

Line 49: SELECT fnd.user_name VIEWER

45: l_pub_end_date VARCHAR2(20);
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;

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 51: WHERE acc.user_id = fnd.user_id AND acc.party_id = cp_viewer;

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);
55: l_port_id NUMBER(15);

Line 91: -- get fnd user name, the Adhoc Role will send mail to FND USER.

87: ELSE
88: l_viewer_id := SUBSTR(l_viewer_ids, l_start_pos, l_cur_pos - l_start_pos);
89: END IF;
90:
91: -- get fnd user name, the Adhoc Role will send mail to FND USER.
92:
93: OPEN c_viewer(l_viewer_id);
94: FETCH c_viewer INTO rec_viewer;
95: EXIT WHEN c_viewer%NOTFOUND;

Line 448: fnd_user fu,

444: CURSOR c_viewer_info(cp_viewer IN NUMBER) IS
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;

Line 550: SELECT port.portfolio_name, fnd.user_name

546:
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 ;

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:

Line 553: fnd.user_id = acc.user_id AND

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:
556: rec_port_info c_port_info%ROWTYPE;
557: l_stmt varchar2(32000);