DBA Data[Home] [Help]

APPS.HXC_SUPERVISOR_DASHBOARD dependencies on HXC_TC_AP_LINKS

Line 1450: ,hxc_tc_ap_links hta

1446: IS
1447: SELECT htt.timecard_id
1448: ,hta.application_period_id
1449: FROM hxc_temp_tcd htt
1450: ,hxc_tc_ap_links hta
1451: WHERE htt.timecard_id = hta.application_period_id
1452: AND htt.timecard_id IS NOT NULL
1453: AND htt.user_id = p_user_id;
1454:

Line 1459: FROM hxc_tc_ap_links htal

1455: CURSOR c_get_notif_ids(p_timecard_id number, p_user_name varchar2)
1456: IS
1457: SELECT htal.timecard_id
1458: ,wias.notification_id
1459: FROM hxc_tc_ap_links htal
1460: ,hxc_app_period_summary haps
1461: ,wf_item_attribute_values wiav
1462: ,wf_item_activity_statuses wias
1463: ,wf_notifications wf