APPS.HXC_TIME_APPROVAL_INFO dependencies on HXC_TC_AP_LINKS

Line 23: (p_tc_id in hxc_tc_ap_links.timecard_id%type) is

19: procedure createApplicationCache
20: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
21:
22: cursor c_ap_cache_info
23: (p_tc_id in hxc_tc_ap_links.timecard_id%type) is
24: select aps.application_period_id,
25: aps.approval_status,
26: aps.creation_date,
27: aps.notification_status,

Line 30: from hxc_tc_ap_links tcl,

26: aps.creation_date,
27: aps.notification_status,
28: aps.approver_id,
29: aps.time_recipient_id
30: from hxc_tc_ap_links tcl,
31: hxc_app_period_summary aps
32: where tcl.timecard_id = p_tc_id
33: and tcl.application_period_id = aps.application_period_id;
34:

Line 65: from hxc_tc_ap_links tcl, hxc_app_period_summary aps

61:
62: cursor c_approval_date
63: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
64: select max(aps.creation_date)
65: from hxc_tc_ap_links tcl, hxc_app_period_summary aps
66: where tcl.timecard_id = p_timecard_id
67: and aps.approval_status = 'APPROVED'
68: and aps.application_period_id = tcl.application_period_id;
69:

Line 231: from hxc_tc_ap_links

227:
228: cursor c_find_timecard_id
229: (p_app_period_id in hxc_app_period_summary.application_period_id%type) is
230: select timecard_id
231: from hxc_tc_ap_links
232: where application_period_id = p_app_period_id;
233:
234: l_timecard_id hxc_timecard_summary.timecard_id%type;
235: