DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_HELPER dependencies on HXC_TC_AP_LINKS

Line 487: from hxc_tc_ap_links htal, hxc_app_period_summary happs

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:

Line 793: from hxc_tc_ap_links tcl,

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:

Line 1078: from hxc_tc_ap_links tcl, hxc_timecard_summary hts

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:

Line 1694: from hxc_tc_ap_links tcl,

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: