DBA Data[Home] [Help]

APPS.POA_REPORT_UTIL dependencies on FND_USER

Line 759: FROM fnd_user_resp_groups

755: (SELECT id
756: FROM bis_sets_of_books_v
757: WHERE responsibility_id IN
758: (SELECT responsibility_id
759: FROM fnd_user_resp_groups
760: WHERE user_id = FND_GLOBAL.user_id
761: AND sysdate BETWEEN start_date and nvl(end_date, sysdate+1)))));
762:
763: BEGIN

Line 854: FROM fnd_user_resp_groups

850: and organization_id IN
851: (SELECT id from bis_operating_units_v
852: WHERE responsibility_id IN
853: (SELECT responsibility_id
854: FROM fnd_user_resp_groups
855: WHERE user_id = FND_GLOBAL.user_id
856: AND sysdate BETWEEN start_date and nvl(end_date, sysdate+1)));
857:
858: BEGIN

Line 919: FROM fnd_user_resp_groups

915: and organization_id IN
916: (SELECT id FROM bis_operating_units_v
917: WHERE responsibility_id IN
918: (SELECT responsibility_id
919: FROM fnd_user_resp_groups
920: WHERE user_id = FND_GLOBAL.user_id
921: AND sysdate between start_date and nvl(end_date, sysdate+1)));
922: BEGIN
923: IF (p_oper_unit_name IS NULL OR p_oper_unit_name = '') THEN

Line 990: FROM fnd_user

986:
987: IF p_user_id is null then
988: SELECT user_id
989: INTO l_user_id
990: FROM fnd_user
991: WHERE user_name = p_user_name;
992: ELSE
993: l_user_id := p_user_id;
994: END IF;