APPS.PER_OTHERBG_APL_API dependencies on PER_VAC_LINKED_ASSIGNMENTS

Line 174: from per_vac_linked_assignments

170: l_proc varchar2(72) := g_package||'close_source_application';
171:
172: cursor csr_irc_asg(l_tgt_assignment_id per_all_assignments_f.assignment_id%type,l_effective_date date) is
173: select src_apl_asg_id
174: from per_vac_linked_assignments
175: where tgt_apl_asg_id = l_tgt_assignment_id
176: and l_effective_date between trunc(nvl(start_date,l_effective_date)) and trunc(nvl(end_date,l_effective_date)) ;
177:
178: l_src_apl_asg_id per_all_assignments_f.assignment_id%type;

Line 206: from per_vac_linked_assignments

202: l_proc varchar2(72) := g_package||'close_target_applications';
203:
204: cursor csr_irc_src_asg(l_src_assignment_id per_all_assignments_f.assignment_id%type,l_effective_date date) is
205: select tgt_apl_asg_id
206: from per_vac_linked_assignments
207: where src_apl_asg_id = l_src_assignment_id
208: and l_effective_date between trunc(nvl(start_date,l_effective_date)) and trunc(nvl(end_date,l_effective_date))
209: and tgt_apl_asg_id <> apl_assignment_id;
210:

Line 271: from per_vac_linked_assignments

267: l_proc varchar2(72) := g_package||'open_source_application';
268:
269: cursor csr_irc_asg(l_tgt_assignment_id per_all_assignments_f.assignment_id%type,l_effective_date date) is
270: select src_apl_asg_id
271: from per_vac_linked_assignments
272: where tgt_apl_asg_id = l_tgt_assignment_id;
273:
274: l_src_apl_asg_id per_all_assignments_f.assignment_id%type;
275:

Line 322: from PER_VAC_LINKED_ASSIGNMENTS

318: is
319: l_proc varchar2(72) := g_package||'isMultiRegVac';
320: cursor cur_tgt_applications is
321: select SRC_APL_ASG_ID
322: from PER_VAC_LINKED_ASSIGNMENTS
323: where TGT_APL_ASG_ID = apl_assignment_id;
324:
325: cursor cur_src_applications is
326: select TGT_APL_ASG_ID

Line 327: from PER_VAC_LINKED_ASSIGNMENTS

323: where TGT_APL_ASG_ID = apl_assignment_id;
324:
325: cursor cur_src_applications is
326: select TGT_APL_ASG_ID
327: from PER_VAC_LINKED_ASSIGNMENTS
328: where SRC_APL_ASG_ID = apl_assignment_id;
329: --
330: l_tgt_apl_asg_id per_vac_linked_assignments.tgt_apl_asg_id%type;
331: is_muti_regional_vacancy boolean :=false;

Line 330: l_tgt_apl_asg_id per_vac_linked_assignments.tgt_apl_asg_id%type;

326: select TGT_APL_ASG_ID
327: from PER_VAC_LINKED_ASSIGNMENTS
328: where SRC_APL_ASG_ID = apl_assignment_id;
329: --
330: l_tgt_apl_asg_id per_vac_linked_assignments.tgt_apl_asg_id%type;
331: is_muti_regional_vacancy boolean :=false;
332: --
333: begin
334: hr_utility.set_location('Entering:'|| l_proc, 5);