APPS.PAY_BATCH_ELEMENT_LINK_PKG dependencies on PAY_BATCH_ELEMENT_LINKS

Line 59: from pay_batch_element_links

55: )
56: is
57: cursor csr_new_rowid is
58: select rowid
59: from pay_batch_element_links
60: where batch_element_link_id = p_batch_element_link_id
61: ;
62: --
63: cursor csr_next_ID is

Line 78: insert into pay_batch_element_links(

74: fetch csr_next_ID into p_batch_element_link_id;
75: close csr_next_ID;
76: end if;
77: --
78: insert into pay_batch_element_links(
79: --
80: batch_element_link_id,
81: effective_date,
82: element_link_id,

Line 250: from pay_batch_element_links

246: is
247: --
248: cursor csr_locked_row is
249: select *
250: from pay_batch_element_links
251: where rowid = p_rowid
252: for update NOWAIT;
253: --
254: locked_row csr_locked_row%rowtype;

Line 489: update pay_batch_element_links

485: begin
486: --
487: hr_utility.set_location('Entering: '||l_proc, 5);
488: --
489: update pay_batch_element_links
490: set
491: batch_element_link_id = p_batch_element_link_id
492: ,element_link_id = p_element_link_id
493: ,effective_date = p_effective_date

Line 560: from pay_batch_element_links

556: --
557: hr_utility.set_location('Entering: '||l_proc, 5);
558: --
559: select batch_element_link_id into l_batch_element_link_id
560: from pay_batch_element_links
561: where rowid = p_rowid;
562: --
563: pay_batch_object_status_pkg.delete_object_status
564: (p_object_type => 'BEL'

Line 569: delete from pay_batch_element_links

565: ,p_object_id => l_batch_element_link_id
566: ,p_payroll_action_id => null
567: );
568: --
569: delete from pay_batch_element_links
570: where rowid = p_rowid;
571: --
572: if sql%notfound then
573: raise no_data_found;