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: -- bug no 9248094
176: l_msg varchar2(2000);
177:
178: begin

Line 247: insert into PER_ALL_PEOPLE_F

243: end if;
244: --
245: /* END OF WWBUG 1975359 */
246: --
247: insert into PER_ALL_PEOPLE_F
248: (person_id
249: ,effective_start_date
250: ,effective_end_date
251: ,business_group_id

Line 561: update per_all_people_f

557: hr_utility.set_location('Updating party id',10);
558: --
559: -- Now assign the resulting party id back to the record.
560: --
561: update per_all_people_f
562: set party_id = l_person.party_id
563: where person_id = p_person_id;
564: --
565: -- END TCA_UNMERGE CHANGES

Line 748: from per_all_people_f

744: -- bug 4635241 starts here
745: --
746: cursor c_person is
747: select *
748: from per_all_people_f
749: where rowid=chartorowid(p_rowid);
750:
751: cursor c_person1(p_esd per_all_people_f.effective_start_date%type
752: ,personid per_all_people_f.person_id%type) is

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

747: select *
748: from per_all_people_f
749: where rowid=chartorowid(p_rowid);
750:
751: cursor c_person1(p_esd per_all_people_f.effective_start_date%type
752: ,personid per_all_people_f.person_id%type) is
753: select *
754: from per_all_people_f
755: where effective_start_date between p_esd and sysdate

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

748: from per_all_people_f
749: where rowid=chartorowid(p_rowid);
750:
751: cursor c_person1(p_esd per_all_people_f.effective_start_date%type
752: ,personid per_all_people_f.person_id%type) is
753: select *
754: from per_all_people_f
755: where effective_start_date between p_esd and sysdate
756: and person_id=personid

Line 754: from per_all_people_f

750:
751: cursor c_person1(p_esd per_all_people_f.effective_start_date%type
752: ,personid per_all_people_f.person_id%type) is
753: select *
754: from per_all_people_f
755: where effective_start_date between p_esd and sysdate
756: and person_id=personid
757: and effective_end_date > sysdate;
758:

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

755: where effective_start_date between p_esd and sysdate
756: and person_id=personid
757: and effective_end_date > sysdate;
758:
759: cursor c_person2(p_esd per_all_people_f.effective_start_date%type
760: ,personid per_all_people_f.person_id%type) is
761: select *
762: from per_all_people_f
763: where effective_start_date < p_esd

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

756: and person_id=personid
757: and effective_end_date > sysdate;
758:
759: cursor c_person2(p_esd per_all_people_f.effective_start_date%type
760: ,personid per_all_people_f.person_id%type) is
761: select *
762: from per_all_people_f
763: where effective_start_date < p_esd
764: and person_id=personid

Line 762: from per_all_people_f

758:
759: cursor c_person2(p_esd per_all_people_f.effective_start_date%type
760: ,personid per_all_people_f.person_id%type) is
761: select *
762: from per_all_people_f
763: where effective_start_date < p_esd
764: and person_id=personid
765: and effective_end_date > sysdate;
766:

Line 767: l_person_rec per_all_people_f%rowtype;

763: where effective_start_date < p_esd
764: and person_id=personid
765: and effective_end_date > sysdate;
766:
767: l_person_rec per_all_people_f%rowtype;
768: l_person_rec1 per_all_people_f%rowtype :=NULL;
769: --
770: -- bug 4635241 ends here
771:

Line 768: l_person_rec1 per_all_people_f%rowtype :=NULL;

764: and person_id=personid
765: and effective_end_date > sysdate;
766:
767: l_person_rec per_all_people_f%rowtype;
768: l_person_rec1 per_all_people_f%rowtype :=NULL;
769: --
770: -- bug 4635241 ends here
771:
772: -- Bug 10171874 starts

Line 776: from per_all_people_f p1

772: -- Bug 10171874 starts
773: cursor csr_tca_person (p_efd date,p_personid number)
774: is
775: select *
776: from per_all_people_f p1
777: where person_id = p_personid
778: and p_efd between effective_start_date and effective_end_date;
779:
780: l_tca_person_rec per_all_people_f%rowtype;

Line 780: l_tca_person_rec per_all_people_f%rowtype;

776: from per_all_people_f p1
777: where person_id = p_personid
778: and p_efd between effective_start_date and effective_end_date;
779:
780: l_tca_person_rec per_all_people_f%rowtype;
781:
782: --Bug 10171874 ends
783:
784: begin

Line 798: delete from per_all_people_f

794: -- bug 4635241 end here
795: --
796: hr_utility.set_location('Leaving: per_people11_pkg.delete_row1',20);
797:
798: delete from per_all_people_f
799: where rowid=chartorowid(p_rowid);
800: --
801: -- bug 4635241 starts here
802: --