DBA Data[Home] [Help]

APPS.HR_PER_TYPE_USAGE_INTERNAL dependencies on PER_ALL_PEOPLE_F

Line 67: from per_all_people_f

63: --
64: -- BEGIN TCA_UNMERGE CHANGES
65: cursor c_person is
66: select *
67: from per_all_people_f
68: where person_id = p_person_id
69: and p_effective_date
70: between effective_start_date
71: and effective_end_date;

Line 73: l_person per_all_people_f%rowtype;

69: and p_effective_date
70: between effective_start_date
71: and effective_end_date;
72: --
73: l_person per_all_people_f%rowtype;
74: --
75: -- TCA_UNMERGE
76: begin
77: --

Line 620: from per_all_people_f

616: --
617: -- BEGIN TCA_UNMERGE CHANGES
618: cursor c_person is
619: select *
620: from per_all_people_f
621: where person_id = p_person_id
622: and p_effective_date
623: between effective_start_date
624: and effective_end_date;

Line 626: l_person per_all_people_f%rowtype;

622: and p_effective_date
623: between effective_start_date
624: and effective_end_date;
625: --
626: l_person per_all_people_f%rowtype;
627: --
628: -- TCA_UNMERGE
629: begin
630: --

Line 1027: from per_all_people_f

1023: --
1024: -- BEGIN TCA_UNMERGE CHANGES
1025: cursor c_person is
1026: select *
1027: from per_all_people_f
1028: where person_id = p_person_id
1029: and p_effective_date
1030: between effective_start_date
1031: and effective_end_date;

Line 1033: l_person per_all_people_f%rowtype;

1029: and p_effective_date
1030: between effective_start_date
1031: and effective_end_date;
1032: --
1033: l_person per_all_people_f%rowtype;
1034: --
1035: -- TCA_UNMERGE
1036: --
1037: begin