eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 216: from per_all_assignments_f asg

212: is
213:
214: cursor csr_get_supervisor(b_person_id number, b_effective_date date) is
215: select asg.supervisor_id
216: from per_all_assignments_f asg
217: where asg.person_id = b_person_id
218: and TRUNC(b_effective_date) between TRUNC(asg.effective_Start_date) and TRUNC(asg.effective_end_date)
219: and asg.primary_flag = 'Y'
220: and asg.assignment_type in ('E','C');

Line 222: l_supervisor_id per_all_assignments_f.person_id%type;

218: and TRUNC(b_effective_date) between TRUNC(asg.effective_Start_date) and TRUNC(asg.effective_end_date)
219: and asg.primary_flag = 'Y'
220: and asg.assignment_type in ('E','C');
221:
222: l_supervisor_id per_all_assignments_f.person_id%type;
223: begin
224: open csr_get_supervisor(p_person_id, trunc(p_effective_date));
225: fetch csr_get_supervisor into l_supervisor_id;
226: close csr_get_supervisor;

Line 1803: l_apr_person_id per_all_assignments_f.person_id%type;

1799:
1800: l_proc constant varchar2(61) := g_pkg || '.' || 'person_approval';
1801: l_effective_end_date date;
1802: l_effective_start_date date;
1803: l_apr_person_id per_all_assignments_f.person_id%type;
1804: l_login fnd_user.user_name%type;
1805: --
1806: -- Bug 4153585
1807: -- Increased size for translation

Line 2198: l_person_id per_all_assignments_f.person_id%type;

2194: l_default_timeout number;
2195: --
2196: -- person who requires approval
2197: --
2198: l_person_id per_all_assignments_f.person_id%type;
2199: --
2200: l_supervisor_id per_all_assignments_f.supervisor_id%type;
2201: l_next_supervisor_id per_all_assignments_f.supervisor_id%type;
2202: l_login fnd_user.user_name%type;

Line 2200: l_supervisor_id per_all_assignments_f.supervisor_id%type;

2196: -- person who requires approval
2197: --
2198: l_person_id per_all_assignments_f.person_id%type;
2199: --
2200: l_supervisor_id per_all_assignments_f.supervisor_id%type;
2201: l_next_supervisor_id per_all_assignments_f.supervisor_id%type;
2202: l_login fnd_user.user_name%type;
2203: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
2204: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;

Line 2201: l_next_supervisor_id per_all_assignments_f.supervisor_id%type;

2197: --
2198: l_person_id per_all_assignments_f.person_id%type;
2199: --
2200: l_supervisor_id per_all_assignments_f.supervisor_id%type;
2201: l_next_supervisor_id per_all_assignments_f.supervisor_id%type;
2202: l_login fnd_user.user_name%type;
2203: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
2204: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
2205:

Line 2850: l_apr_person_id per_all_assignments_f.person_id%type;

2846: l_final_apr varchar2(50);
2847: l_effective_date date;
2848: l_approval_timeout number;
2849: l_default_timeout number;
2850: l_apr_person_id per_all_assignments_f.person_id%type;
2851: l_apr_key_level number;
2852: l_approved_at_level number;
2853: l_approvers_visited number;
2854: begin

Line 3077: l_person_id per_all_assignments_f.person_id%type;

3073: l_approval_mechanism hxc_approval_comps.approval_mechanism%type;
3074: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%type;
3075: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3076: l_wf_process_name hxc_approval_comps.wf_name%type;
3077: l_person_id per_all_assignments_f.person_id%type;
3078: l_formula_status varchar2(10);
3079: l_formula_message varchar2(2000);
3080: begin
3081: --sb_msgs_pkg.begin_call(l_proc);

Line 3422: l_apr_person_id per_all_assignments_f.person_id%type;

3418: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
3419: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
3420: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3421: l_wf_process_name hxc_approval_comps.wf_name%type;
3422: l_apr_person_id per_all_assignments_f.person_id%type;
3423: l_resource_id per_all_assignments_f.person_id%type;
3424: begin
3425: --sb_msgs_pkg.begin_call(l_proc);
3426: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');

Line 3423: l_resource_id per_all_assignments_f.person_id%type;

3419: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
3420: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3421: l_wf_process_name hxc_approval_comps.wf_name%type;
3422: l_apr_person_id per_all_assignments_f.person_id%type;
3423: l_resource_id per_all_assignments_f.person_id%type;
3424: begin
3425: --sb_msgs_pkg.begin_call(l_proc);
3426: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
3427: