483:
484: CURSOR c_get_any_comp_id(p_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE)
485: is
486: select happs.approval_comp_id
487: from hxc_tc_ap_links htal, hxc_app_period_summary happs
488: where htal.timecard_id = p_app_bb_id
489: and happs.application_period_id = htal.application_period_id
490: and rownum <2;
491:
789: from hxc_timecard_summary ts
790: where ts.timecard_id = p_timecard_id
791: union
792: select aps.approval_item_key item_key
793: from hxc_tc_ap_links tcl,
794: hxc_app_period_summary aps
795: where tcl.timecard_id = p_timecard_id
796: and tcl.application_period_id = aps.application_period_id
797:
1074:
1075: is
1076:
1077: select hts.timecard_id,hts.timecard_ovn
1078: from hxc_tc_ap_links tcl, hxc_timecard_summary hts
1079: where tcl.application_period_id = p_app_bb_id
1080: and tcl.timecard_id = hts.timecard_id;
1081:
1082:
1690:
1691: /*CURSOR c_get_app_periods(p_timecard_id in number)
1692: is
1693: select aps.application_period_id
1694: from hxc_tc_ap_links tcl,
1695: hxc_app_period_summary aps
1696: where tcl.timecard_id = p_timecard_id
1697: and tcl.application_period_id = aps.application_period_id ;*/
1698: