APPS.PAY_ELEMENT_LINKS_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 258: from pay_element_links_f

254: v_link_end_date date;
255: --
256: cursor csr_link is
257: select max(effective_end_date)
258: from pay_element_links_f
259: where element_link_id = p_link_id;
260: --
261: begin
262: open csr_link;

Line 319: from pay_element_links_f

315: p_attribute19 varchar2,
316: p_attribute20 varchar2) is
317: cursor csr_new_rowid is
318: select rowid
319: from pay_element_links_f
320: where element_link_id = p_element_link_id
321: and effective_start_date = p_effective_start_date
322: and effective_end_date = p_effective_end_date;
323: --

Line 360: insert into pay_element_links_f(

356: end if;
357:
358: */
359: --
360: insert into pay_element_links_f(
361: --
362: element_link_id,
363: effective_start_date,
364: effective_end_date,

Line 528: from pay_element_links_f

524: p_attribute20 varchar2) is
525: --
526: cursor csr_locked_row is
527: select *
528: from pay_element_links_f
529: where rowid = p_rowid
530: for update of element_link_id NOWAIT;
531: --
532: locked_row csr_locked_row%rowtype;

Line 820: update pay_element_links_f

816: hr_utility.raise_error;
817:
818: end if;
819:
820: update pay_element_links_f
821: set element_link_id = p_element_link_id,
822: effective_start_date = p_effective_start_date,
823: effective_end_date = p_effective_end_date,
824: payroll_id = p_payroll_id,

Line 925: delete from pay_element_links_f

921: p_validation_end_date );
922: --
923: end if;
924: --
925: delete from pay_element_links_f
926: where rowid = p_rowid;
927: --
928: if sql%notfound then
929: raise no_data_found;

Line 1018: from pay_element_links_f LINK,

1014: people_group.segment27,
1015: people_group.segment28,
1016: people_group.segment29,
1017: people_group.segment30
1018: from pay_element_links_f LINK,
1019: pay_people_groups PEOPLE_GROUP
1020: where link.people_group_id = people_group.people_group_id(+)
1021: and link.element_type_id = p_element_type_id
1022: and link.element_link_id <> nvl(p_element_link_id,0)

Line 1390: from pay_element_links_f

1386: v_updates_exist boolean := FALSE;
1387: --
1388: cursor csr_updates is
1389: select 1
1390: from pay_element_links_f
1391: where element_link_id = p_element_link_id
1392: and rowid <> p_rowid;
1393: --
1394: begin