APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on HXC_TIMECARD_SUMMARY

Line 334: (p_timecard_id in hxc_timecard_summary.timecard_id%type,

330:
331: end get_description;
332:
333: function get_description_tc
334: (p_timecard_id in hxc_timecard_summary.timecard_id%type,
335: p_timecard_ovn in hxc_timecard_summary.timecard_ovn%type)
336: return varchar2 is
337:
338: l_description fnd_new_messages.message_text%type;

Line 335: p_timecard_ovn in hxc_timecard_summary.timecard_ovn%type)

331: end get_description;
332:
333: function get_description_tc
334: (p_timecard_id in hxc_timecard_summary.timecard_id%type,
335: p_timecard_ovn in hxc_timecard_summary.timecard_ovn%type)
336: return varchar2 is
337:
338: l_description fnd_new_messages.message_text%type;
339:

Line 810: FROM hxc_timecard_summary tcsum

806: IS
807: SELECT tcsum.resource_id,
808: tcsum.start_time,
809: tcsum.stop_time
810: FROM hxc_timecard_summary tcsum
811: WHERE tcsum.timecard_id = p_tc_bbid;
812:
813:
814: l_proc constant varchar2(61) := g_pkg || '.' || 'find_apr_style';

Line 1570: FROM hxc_timecard_summary tcsum

1566: IS
1567: SELECT tcsum.resource_id,
1568: tcsum.start_time,
1569: tcsum.stop_time
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