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 1070: FROM hxc_timecard_summary tcsum

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

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

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

Line 1078: from hxc_tc_ap_links tcl, hxc_timecard_summary hts

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