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.PER_PEOPLE11_PKG dependencies on PER_ALL_PEOPLE_F

Line 161: from per_all_people_f

157: cursor c1 is select per_people_s.nextval
158: from sys.dual;
159: --
160: cursor c2 is select rowid
161: from per_all_people_f
162: where effective_start_date = p_effective_start_date
163: and effective_end_date = p_effective_end_date
164: and person_id = p_person_id;
165: --

Line 168: from per_all_people_f

164: and person_id = p_person_id;
165: --
166: cursor c_person is
167: select *
168: from per_all_people_f
169: where person_id = p_person_id
170: and p_effective_start_date
171: between effective_start_date
172: and effective_end_date;

Line 174: l_person per_all_people_f%rowtype;

170: and p_effective_start_date
171: between effective_start_date
172: and effective_end_date;
173: --
174: l_person per_all_people_f%rowtype;
175: --
176: begin
177: --
178: -- Test current numbers are not used by

Line 230: insert into PER_ALL_PEOPLE_F

226: end if;
227: --
228: /* END OF WWBUG 1975359 */
229: --
230: insert into PER_ALL_PEOPLE_F
231: (person_id
232: ,effective_start_date
233: ,effective_end_date
234: ,business_group_id

Line 543: update per_all_people_f

539: hr_utility.set_location('Updating party id',10);
540: --
541: -- Now assign the resulting party id back to the record.
542: --
543: update per_all_people_f
544: set party_id = l_person.party_id
545: where person_id = p_person_id;
546: --
547: -- END TCA_UNMERGE CHANGES

Line 730: from per_all_people_f

726: -- bug 4635241 starts here
727: --
728: cursor c_person is
729: select *
730: from per_all_people_f
731: where rowid=chartorowid(p_rowid);
732:
733: cursor c_person1(p_esd per_all_people_f.effective_start_date%type
734: ,personid per_all_people_f.person_id%type) is

Line 733: cursor c_person1(p_esd per_all_people_f.effective_start_date%type

729: select *
730: from per_all_people_f
731: where rowid=chartorowid(p_rowid);
732:
733: cursor c_person1(p_esd per_all_people_f.effective_start_date%type
734: ,personid per_all_people_f.person_id%type) is
735: select *
736: from per_all_people_f
737: where effective_start_date between p_esd and sysdate

Line 734: ,personid per_all_people_f.person_id%type) is

730: from per_all_people_f
731: where rowid=chartorowid(p_rowid);
732:
733: cursor c_person1(p_esd per_all_people_f.effective_start_date%type
734: ,personid per_all_people_f.person_id%type) is
735: select *
736: from per_all_people_f
737: where effective_start_date between p_esd and sysdate
738: and person_id=personid

Line 736: from per_all_people_f

732:
733: cursor c_person1(p_esd per_all_people_f.effective_start_date%type
734: ,personid per_all_people_f.person_id%type) is
735: select *
736: from per_all_people_f
737: where effective_start_date between p_esd and sysdate
738: and person_id=personid
739: and effective_end_date > sysdate;
740:

Line 741: cursor c_person2(p_esd per_all_people_f.effective_start_date%type

737: where effective_start_date between p_esd and sysdate
738: and person_id=personid
739: and effective_end_date > sysdate;
740:
741: cursor c_person2(p_esd per_all_people_f.effective_start_date%type
742: ,personid per_all_people_f.person_id%type) is
743: select *
744: from per_all_people_f
745: where effective_start_date < p_esd

Line 742: ,personid per_all_people_f.person_id%type) is

738: and person_id=personid
739: and effective_end_date > sysdate;
740:
741: cursor c_person2(p_esd per_all_people_f.effective_start_date%type
742: ,personid per_all_people_f.person_id%type) is
743: select *
744: from per_all_people_f
745: where effective_start_date < p_esd
746: and person_id=personid

Line 744: from per_all_people_f

740:
741: cursor c_person2(p_esd per_all_people_f.effective_start_date%type
742: ,personid per_all_people_f.person_id%type) is
743: select *
744: from per_all_people_f
745: where effective_start_date < p_esd
746: and person_id=personid
747: and effective_end_date > sysdate;
748:

Line 749: l_person_rec per_all_people_f%rowtype;

745: where effective_start_date < p_esd
746: and person_id=personid
747: and effective_end_date > sysdate;
748:
749: l_person_rec per_all_people_f%rowtype;
750: l_person_rec1 per_all_people_f%rowtype :=NULL;
751: --
752: -- bug 4635241 ends here
753:

Line 750: l_person_rec1 per_all_people_f%rowtype :=NULL;

746: and person_id=personid
747: and effective_end_date > sysdate;
748:
749: l_person_rec per_all_people_f%rowtype;
750: l_person_rec1 per_all_people_f%rowtype :=NULL;
751: --
752: -- bug 4635241 ends here
753:
754: begin

Line 764: delete from per_all_people_f

760: close c_person;
761:
762: -- bug 4635241 end here
763: --
764: delete from per_all_people_f
765: where rowid=chartorowid(p_rowid);
766: --
767: -- bug 4635241 starts here
768: --