DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_HELPER dependencies on HXC_APPROVAL_COMPS

Line 495: from hxc_approval_comps hac,

491:
492: cursor c_app_comp_pm(p_bb_id number,p_bb_ovn number)
493: is
494: select hac.approval_comp_id
495: from hxc_approval_comps hac,
496: hxc_approval_styles has,
497: hxc_time_building_blocks htb
498: where htb.time_building_block_id =p_bb_id
499: and htb.object_version_number = p_bb_ovn

Line 807: hxc_approval_comps d

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)
811: and a.application_period_id <>p_app_period_id