APPS.HXC_TIMECARD_UTILITIES dependencies on HXC_TIMECARD_SUMMARY

Line 503: FROM hxc_timecard_summary

499:
500: CURSOR get_leading_timecards( p_resource_id IN NUMBER,
501: p_start_time IN DATE)
502: IS SELECT COUNT(1)
503: FROM hxc_timecard_summary
504: START WITH resource_id = p_resource_id
505: AND start_time = p_start_time
506: CONNECT BY resource_id = p_resource_id
507: AND PRIOR TRUNC(stop_time) + 1 = start_time;

Line 513: FROM hxc_timecard_summary

509:
510: CURSOR get_lagging_timecards( p_resource_id IN NUMBER,
511: p_stop_time IN DATE)
512: IS SELECT COUNT(1)
513: FROM hxc_timecard_summary
514: START WITH resource_id = p_resource_id
515: AND start_time < p_stop_time
516: AND stop_time = p_stop_time
517: CONNECT BY resource_id = p_resource_id

Line 2918: ,hxc_timecard_summary hts

2914: , fad.automatically_added_flag
2915: , fad.category_id
2916: FROM hxc_time_building_blocks app
2917: ,hxc_tc_ap_links htal
2918: ,hxc_timecard_summary hts
2919: ,fnd_attached_documents fad
2920: WHERE app.scope = 'APPLICATION_PERIOD'
2921: AND app.date_to = hr_general.end_of_time
2922: AND app.resource_id = to_number(p_resource_id)

Line 2932: AND fad.entity_name = 'HXC_TIMECARD_SUMMARY'

2928: AND htal.timecard_id = hts.timecard_id
2929: AND hts.resource_id = to_number(fad.pk1_value)
2930: AND regexp_replace(fnd_date.date_to_canonical(trunc(hts.start_time)),' .*') = fad.pk2_value
2931: AND regexp_replace(fnd_date.date_to_canonical(trunc(hts.stop_time)),' .*') = fad.pk3_value
2932: AND fad.entity_name = 'HXC_TIMECARD_SUMMARY'
2933: ;
2934:
2935: TYPE num_tab IS TABLE OF NUMBER;
2936: TYPE varchar_tab IS TABLE OF VARCHAR2(200);

Line 3009: ( X_entity_name => 'HXC_TIMECARD_SUMMARY'

3005: hr_utility.trace('call to delete approval period attachments...fnd_attached_documents2_pkg.delete_attachments');
3006: END IF;
3007:
3008: fnd_attached_documents2_pkg.delete_attachments
3009: ( X_entity_name => 'HXC_TIMECARD_SUMMARY'
3010: , X_pk1_value => l_app_resource_id_tab(l_app_resource_id_tab.FIRST)
3011: , X_pk2_value => l_app_start_date_tab(l_app_resource_id_tab.FIRST)
3012: , X_pk3_value => l_app_end_date_tab(l_app_resource_id_tab.FIRST)
3013: , X_delete_document_flag => 'Y'