755: CURSOR c_get_detail_blocks(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type)
756: is
757: select adl.time_building_block_id,
758: adl.time_building_block_ovn
759: from hxc_ap_detail_links adl
760: where adl.application_period_id = p_application_period_id;
761:
762:
763: CURSOR c_get_notifications(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
800: CURSOR c_chk_auto_approve(p_app_bb_id in number)
801: is
802:
803: select d.approval_mechanism
804: from hxc_ap_detail_links a,
805: hxc_latest_details b,
806: hxc_app_period_summary c,
807: hxc_approval_comps d
808: where a.time_building_block_id in (select time_building_block_id
805: hxc_latest_details b,
806: hxc_app_period_summary c,
807: hxc_approval_comps d
808: where a.time_building_block_id in (select time_building_block_id
809: from hxc_ap_detail_links
810: where application_period_id =p_app_period_id)
811: and a.application_period_id <>p_app_period_id
812: and b.time_building_block_id = a.time_building_block_id
813: and b.object_version_number = a.time_building_block_ovn