DBA Data[Home] [Help]

APPS.FII_USER_SEC_OPTIMIZER dependencies on FND_USER

Line 102: fnd_user u

98: sysdate, g_fii_user_id,
99: sysdate, g_fii_user_id, g_fii_login_id
100: FROM bis_grants_v s, --user_security_initial2 s,
101: fii_com_pmv_agrt_nodes h,
102: fnd_user u
103: WHERE decode(s.granted_for,
104: -999, l_company_top_node_id,
105: s.granted_for) = h.company_id
106: AND s.delegation_parameter='FII_COMPANIES'

Line 134: fnd_user u

130: sysdate, g_fii_user_id,
131: sysdate, g_fii_user_id, g_fii_login_id
132: FROM bis_grants_v s, --user_security_initial2 s,
133: fii_cc_pmv_agrt_nodes h,
134: fnd_user u
135: WHERE decode(s.granted_for,
136: -999, l_cost_ctr_top_node_id,
137: s.granted_for) = h.cost_center_id
138: AND s.delegation_parameter='HRI_CL_ORGCC'