APPS.HXC_APPROVAL_WF_HELPER dependencies on HXC_APP_PERIOD_SUMMARY

Line 481: from hxc_app_period_summary

477:
478: CURSOR c_get_app_comp_id(p_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE)
479: is
480: select approval_comp_id
481: from hxc_app_period_summary
482: where application_period_id = p_app_bb_id;
483:
484: CURSOR c_get_any_comp_id(p_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE)
485: is

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 794: hxc_app_period_summary aps

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:
798: );

Line 806: hxc_app_period_summary c,

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
809: from hxc_ap_detail_links
810: where application_period_id =p_app_period_id)

Line 821: from hxc_app_period_summary

817:
818: CURSOR c_get_app_dates(p_app_bb_id in number)
819: is
820: select start_time,stop_time
821: from hxc_app_period_summary
822: where application_period_id = p_app_bb_id;
823:
824: CURSOR c_get_tc_dates(p_timecard_id in number)
825: is

Line 1712: hxc_app_period_summary aps

1708: /*CURSOR c_get_app_periods(p_timecard_id in number)
1709: is
1710: select aps.application_period_id
1711: from hxc_tc_ap_links tcl,
1712: hxc_app_period_summary aps
1713: where tcl.timecard_id = p_timecard_id
1714: and tcl.application_period_id = aps.application_period_id ;*/
1715:
1716: CURSOR get_result

Line 1741: update hxc_app_period_summary

1737: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
1738: itemkey => itemkey,
1739: aname => 'APP_BB_OVN');
1740:
1741: update hxc_app_period_summary
1742: set approval_status = 'SUBMITTED'
1743: where application_period_id = l_app_bb_id
1744: and application_period_ovn = l_app_bb_ovn;
1745: end if;