APPS.PAY_ELEMENT_LINKS_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 267: from pay_element_links_f

263: v_link_end_date date;
264: --
265: cursor csr_link is
266: select max(effective_end_date)
267: from pay_element_links_f
268: where element_link_id = p_link_id;
269: --
270: begin
271: open csr_link;

Line 328: from pay_element_links_f

324: p_attribute19 varchar2,
325: p_attribute20 varchar2) is
326: cursor csr_new_rowid is
327: select rowid
328: from pay_element_links_f
329: where element_link_id = p_element_link_id
330: and effective_start_date = p_effective_start_date
331: and effective_end_date = p_effective_end_date;
332: --

Line 369: insert into pay_element_links_f(

365: end if;
366:
367: */
368: --
369: insert into pay_element_links_f(
370: --
371: element_link_id,
372: effective_start_date,
373: effective_end_date,

Line 537: from pay_element_links_f

533: p_attribute20 varchar2) is
534: --
535: cursor csr_locked_row is
536: select *
537: from pay_element_links_f
538: where rowid = p_rowid
539: for update of element_link_id NOWAIT;
540: --
541: locked_row csr_locked_row%rowtype;

Line 829: update pay_element_links_f

825: hr_utility.raise_error;
826:
827: end if;
828:
829: update pay_element_links_f
830: set element_link_id = p_element_link_id,
831: effective_start_date = p_effective_start_date,
832: effective_end_date = p_effective_end_date,
833: payroll_id = p_payroll_id,

Line 934: delete from pay_element_links_f

930: p_validation_end_date );
931: --
932: end if;
933: --
934: delete from pay_element_links_f
935: where rowid = p_rowid;
936: --
937: if sql%notfound then
938: raise no_data_found;

Line 1027: from pay_element_links_f LINK,

1023: people_group.segment27,
1024: people_group.segment28,
1025: people_group.segment29,
1026: people_group.segment30
1027: from pay_element_links_f LINK,
1028: pay_people_groups PEOPLE_GROUP
1029: where link.people_group_id = people_group.people_group_id(+)
1030: and link.element_type_id = p_element_type_id
1031: and link.element_link_id <> nvl(p_element_link_id,0)

Line 1401: from pay_element_links_f

1397: v_updates_exist boolean := FALSE;
1398: --
1399: cursor csr_updates is
1400: select 1
1401: from pay_element_links_f
1402: where element_link_id = p_element_link_id
1403: and rowid <> p_rowid;
1404: --
1405: begin