APPS.HXC_WF_ERROR_HELPER dependencies on HXC_TIME_BUILDING_BLOCKS

Line 42: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE

38: l_recipient_id number;
39: l_proc constant varchar2(61) := g_pkg ||'prepare_error';
40:
41: CURSOR c_tc_info(
42: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE
43: )
44: IS
45: SELECT tcsum.resource_id,
46: tcsum.start_time,

Line 52: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE

48: FROM hxc_timecard_summary tcsum
49: WHERE tcsum.timecard_id = p_tc_bbid;
50:
51: CURSOR c_tc_info_tbb(
52: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE
53: )
54: IS
55: select htb.resource_id, htb.start_time,htb.stop_time
56: from hxc_time_building_blocks htb

Line 56: from hxc_time_building_blocks htb

52: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE
53: )
54: IS
55: select htb.resource_id, htb.start_time,htb.stop_time
56: from hxc_time_building_blocks htb
57: where htb.time_building_block_id =p_tc_bbid
58: and htb.scope = 'TIMECARD'
59: and htb.object_version_number = (select max(object_version_number)
60: from hxc_time_building_blocks htb1

Line 60: from hxc_time_building_blocks htb1

56: from hxc_time_building_blocks htb
57: where htb.time_building_block_id =p_tc_bbid
58: and htb.scope = 'TIMECARD'
59: and htb.object_version_number = (select max(object_version_number)
60: from hxc_time_building_blocks htb1
61: where htb.time_building_block_id =htb1.time_building_block_id);
62:
63:
64: CURSOR c_get_error(p_itemkey wf_items.item_key%type)