APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on HXC_APPROVAL_STYLES

Line 50: HXC_APPROVAL_STYLES aps,

46: apc.approval_mechanism_id,
47: apc.wf_item_type,
48: apc.wf_name
49: FROM HXC_APPROVAL_COMPS apc,
50: HXC_APPROVAL_STYLES aps,
51: HXC_TIME_BUILDING_BLOCKS htb_time,
52: hxc_time_building_blocks htb_appln
53: WHERE htb_appln.TIME_BUILDING_BLOCK_ID = b_ap_bbid AND
54: htb_appln.object_version_number = b_ap_bbovn

Line 2166: FROM hxc_approval_styles

2162: AND approval_comp_id = (SELECT approval_comp_id
2163: FROM hxc_approval_comps
2164: WHERE approval_style_id =
2165: (SELECT approval_style_id
2166: FROM hxc_approval_styles
2167: WHERE NAME = 'SEEDED_APPL_PA_MGR')
2168: AND time_category_id = 0);
2169:
2170: