eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1574: p_app_style_id hxc_approval_styles.approval_style_id%TYPE

1570: FROM hxc_timecard_summary tcsum
1571: WHERE tcsum.timecard_id = p_tc_bbid;
1572:
1573: CURSOR c_appr_style(
1574: p_app_style_id hxc_approval_styles.approval_style_id%TYPE
1575: )
1576: IS
1577: SELECT name
1578: FROM hxc_approval_styles

Line 1578: FROM hxc_approval_styles

1574: p_app_style_id hxc_approval_styles.approval_style_id%TYPE
1575: )
1576: IS
1577: SELECT name
1578: FROM hxc_approval_styles
1579: WHERE approval_style_id = p_app_style_id;
1580:
1581: l_proc constant varchar2(61) := g_pkg || '.' || 'auto_approval';
1582: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;

Line 1592: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;

1588: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
1589: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
1590: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
1591:
1592: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
1593: l_approval_style_name hxc_approval_styles.name%TYPE;
1594:
1595: begin
1596: --sb_msgs_pkg.begin_call(l_proc);

Line 1593: l_approval_style_name hxc_approval_styles.name%TYPE;

1589: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
1590: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
1591:
1592: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
1593: l_approval_style_name hxc_approval_styles.name%TYPE;
1594:
1595: begin
1596: --sb_msgs_pkg.begin_call(l_proc);
1597:

Line 2307: FROM hxc_approval_styles

2303: AND approval_comp_id = (SELECT approval_comp_id
2304: FROM hxc_approval_comps
2305: WHERE approval_style_id =
2306: (SELECT approval_style_id
2307: FROM hxc_approval_styles
2308: WHERE NAME = 'SEEDED_APPL_PA_MGR')
2309: AND time_category_id = 0);
2310:
2311: