DBA Data[Home] [Help]

APPS.BIS_PMV_PAGE_PARAMS_PUB dependencies on FND_USER

Line 31: FROM bis_user_attributes bua, fnd_user fu

27: /* Bug 2551994 Modifications to default as of date to sysdate for every login */
28: CURSOR c_lastupdatedate IS
29: SELECT to_char(bua.last_update_date,'RRRR/MM/DD HH24:MI:SS')last_update_date
30: ,bua.attribute_name, bua.session_value, bua.user_id, bua.session_id, bua.function_name
31: FROM bis_user_attributes bua, fnd_user fu
32: WHERE bua.page_id=p_page_id
33: AND bua.user_id = to_char(fu.user_id)
34: AND fu.user_name = p_user_name;
35:

Line 167: FROM bis_user_attributes bua, fnd_user fu

163: )
164: IS
165: CURSOR c_paramstring IS
166: SELECT bua.attribute_name, bua.session_description
167: FROM bis_user_attributes bua, fnd_user fu
168: WHERE bua.page_id=p_page_id AND
169: bua.user_id=to_char(fu.user_id) AND
170: fu.user_name = p_user_name
171: ORDER BY bua.attribute_name;