APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 227: hxc_time_building_blocks htb

223: is
224: select hac.approval_comp_id
225: from hxc_approval_comps hac,
226: hxc_approval_styles has,
227: hxc_time_building_blocks htb
228: where htb.time_building_block_id =p_bb_id
229: and htb.object_version_number = p_bb_ovn
230: and htb.approval_style_id = has.approval_style_id
231: and has.approval_style_id = hac.APPROVAL_STYLE_ID

Line 398: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;

394: l_preparer_full_name per_all_people_f.full_name%type;
395: l_admin_role wf_local_roles.name%type;
396: l_admin_full_name per_all_people_f.full_name%type;
397: l_apr_name per_all_people_f.full_name%type;
398: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
399: l_timecard_ovn hxc_time_building_blocks.time_building_block_id%TYPE;
400: l_tc_stop_date date;
401: l_tc_start_date date;
402: l_effective_start_date date;

Line 399: l_timecard_ovn hxc_time_building_blocks.time_building_block_id%TYPE;

395: l_admin_role wf_local_roles.name%type;
396: l_admin_full_name per_all_people_f.full_name%type;
397: l_apr_name per_all_people_f.full_name%type;
398: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
399: l_timecard_ovn hxc_time_building_blocks.time_building_block_id%TYPE;
400: l_tc_stop_date date;
401: l_tc_start_date date;
402: l_effective_start_date date;
403: l_effective_end_date date;

Line 636: from hxc_time_building_blocks tc

632: p_ovn number
633: )
634: IS
635: select tc.resource_id, tc.start_time, tc.stop_time,tc.last_updated_by
636: from hxc_time_building_blocks tc
637: where tc.time_building_block_id = p_bld_blk_id
638: and tc.object_version_number = p_ovn;
639:
640: CURSOR c_csr_get_appl_periods(

Line 671: hxc_time_building_blocks tbb

667: ta.attribute5,
668: ta.attribute6
669: from hxc_time_attributes ta,
670: hxc_time_attribute_usages tau,
671: hxc_time_building_blocks tbb
672: where tbb.time_building_block_id = p_timecard_bb_id
673: and tbb.object_version_number = p_timecard_ovn
674: and tbb.time_building_block_id = tau.time_building_block_id
675: and tbb.object_version_number = tau.time_building_block_ovn