APPS.HXC_TIMEKEEPER_WF_PKG dependencies on FND_USER

Line 219: from fnd_user u, hxc_time_building_blocks tbb

215: (p_tc_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
216: ,p_tc_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
217: ) is
218: select u.user_name
219: from fnd_user u, hxc_time_building_blocks tbb
220: where tbb.time_building_block_id = p_tc_id
221: and tbb.object_version_number = p_tc_ovn
222: and tbb.last_updated_by = u.user_id;
223:

Line 225: l_login fnd_user.user_name%type;

221: and tbb.object_version_number = p_tc_ovn
222: and tbb.last_updated_by = u.user_id;
223:
224: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.set_login';
225: l_login fnd_user.user_name%type;
226: begin
227:
228: l_login := hxc_find_notify_aprs_pkg.get_login(p_person_id => p_person_id);
229:

Line 803: l_login fnd_user.user_name%type;

799: p_result in out nocopy varchar2)
800: IS
801:
802: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
803: l_login fnd_user.user_name%type;
804: l_fyi_login fnd_user.user_name%type;
805: l_start_date DATE;
806: l_stop_date DATE;
807: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;

Line 804: l_fyi_login fnd_user.user_name%type;

800: IS
801:
802: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
803: l_login fnd_user.user_name%type;
804: l_fyi_login fnd_user.user_name%type;
805: l_start_date DATE;
806: l_stop_date DATE;
807: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
808: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;

Line 995: from fnd_user u, hxc_time_building_blocks tbb

991: (p_tc_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
992: ,p_tc_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
993: ) is
994: select u.user_name
995: from fnd_user u, hxc_time_building_blocks tbb
996: where tbb.time_building_block_id = p_tc_id
997: and tbb.object_version_number = p_tc_ovn
998: and tbb.last_updated_by = u.user_id;
999:

Line 1001: l_login fnd_user.user_name%type;

997: and tbb.object_version_number = p_tc_ovn
998: and tbb.last_updated_by = u.user_id;
999:
1000: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
1001: l_login fnd_user.user_name%type;
1002: l_start_date DATE;
1003: l_stop_date DATE;
1004: l_supervisor hxc_time_building_blocks.resource_id%TYPE;
1005: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;