APPS.HXC_APPROVAL_WF_HELPER dependencies on HXC_TIMECARD_SUMMARY

Line 725: l_tk_audit_item_key hxc_timecard_summary.tk_audit_item_key%type;

721: l_timecard_fyi varchar2(1000);
722: l_item_key wf_items.item_key%type;
723: l_tc_url varchar2(1000);
724: l_block_index PLS_INTEGER := 1;
725: l_tk_audit_item_key hxc_timecard_summary.tk_audit_item_key%type;
726: l_resource_id hxc_time_building_blocks.resource_id%type;
727: l_recipient_action_code wf_item_attribute_values.text_value%type;
728: l_action_code wf_item_attribute_values.text_value%type;
729: l_notification_id wf_notifications.notification_id%type;

Line 789: from hxc_timecard_summary ts

785: and wn.notification_id = wias.notification_id
786: and wias.item_type = 'HXCEMP'
787: and wias.item_key in (
788: select ts.approval_item_key item_key
789: from hxc_timecard_summary ts
790: where ts.timecard_id = p_timecard_id
791: union
792: select aps.approval_item_key item_key
793: from hxc_tc_ap_links tcl,

Line 827: from hxc_timecard_summary

823:
824: CURSOR c_get_tc_dates(p_timecard_id in number)
825: is
826: select start_time,stop_time
827: from hxc_timecard_summary
828: where timecard_id = p_timecard_id;
829:
830:
831: type rec_type is record(p_id hxc_time_building_blocks.time_building_block_id%TYPE,

Line 979: from hxc_timecard_summary

975: end if;
976:
977: select tk_audit_item_key
978: into l_tk_audit_item_key
979: from hxc_timecard_summary
980: where timecard_id= p_timecard_id;
981:
982: if(l_tk_audit_item_key is not null) then
983: hr_utility.trace('TK itemkey '||l_tk_audit_item_key);

Line 1071: FROM hxc_timecard_summary tcsum

1067: IS
1068: SELECT tcsum.resource_id,
1069: tcsum.start_time,
1070: tcsum.stop_time
1071: FROM hxc_timecard_summary tcsum
1072: WHERE tcsum.timecard_id = p_tc_bbid;
1073:
1074: CURSOR get_timecards (p_app_bb_id in hxc_timecard_summary.timecard_id%type)
1075:

Line 1074: CURSOR get_timecards (p_app_bb_id in hxc_timecard_summary.timecard_id%type)

1070: tcsum.stop_time
1071: FROM hxc_timecard_summary tcsum
1072: WHERE tcsum.timecard_id = p_tc_bbid;
1073:
1074: CURSOR get_timecards (p_app_bb_id in hxc_timecard_summary.timecard_id%type)
1075:
1076: is
1077:
1078: select hts.timecard_id,hts.timecard_ovn

Line 1079: from hxc_tc_ap_links tcl, hxc_timecard_summary hts

1075:
1076: is
1077:
1078: select hts.timecard_id,hts.timecard_ovn
1079: from hxc_tc_ap_links tcl, hxc_timecard_summary hts
1080: where tcl.application_period_id = p_app_bb_id
1081: and tcl.timecard_id = hts.timecard_id;
1082:
1083: