APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 176: hxc_time_building_blocks htb

172: is
173: select hac.approval_comp_id
174: from hxc_approval_comps hac,
175: hxc_approval_styles has,
176: hxc_time_building_blocks htb
177: where htb.time_building_block_id =p_bb_id
178: and htb.object_version_number = p_bb_ovn
179: and htb.approval_style_id = has.approval_style_id
180: and has.approval_style_id = hac.APPROVAL_STYLE_ID

Line 347: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;

343: l_preparer_full_name per_all_people_f.full_name%type;
344: l_admin_role wf_local_roles.name%type;
345: l_admin_full_name per_all_people_f.full_name%type;
346: l_apr_name per_all_people_f.full_name%type;
347: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
348: l_timecard_ovn hxc_time_building_blocks.time_building_block_id%TYPE;
349: l_tc_stop_date date;
350: l_tc_start_date date;
351: l_effective_start_date date;

Line 348: l_timecard_ovn hxc_time_building_blocks.time_building_block_id%TYPE;

344: l_admin_role wf_local_roles.name%type;
345: l_admin_full_name per_all_people_f.full_name%type;
346: l_apr_name per_all_people_f.full_name%type;
347: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
348: l_timecard_ovn hxc_time_building_blocks.time_building_block_id%TYPE;
349: l_tc_stop_date date;
350: l_tc_start_date date;
351: l_effective_start_date date;
352: l_effective_end_date date;

Line 585: from hxc_time_building_blocks tc

581: p_ovn number
582: )
583: IS
584: select tc.resource_id, tc.start_time, tc.stop_time,tc.last_updated_by
585: from hxc_time_building_blocks tc
586: where tc.time_building_block_id = p_bld_blk_id
587: and tc.object_version_number = p_ovn;
588:
589: CURSOR c_csr_get_appl_periods(

Line 620: hxc_time_building_blocks tbb

616: ta.attribute5,
617: ta.attribute6
618: from hxc_time_attributes ta,
619: hxc_time_attribute_usages tau,
620: hxc_time_building_blocks tbb
621: where tbb.time_building_block_id = p_timecard_bb_id
622: and tbb.object_version_number = p_timecard_ovn
623: and tbb.time_building_block_id = tau.time_building_block_id
624: and tbb.object_version_number = tau.time_building_block_ovn