APPS.PAY_ASG_DEBUG_PKG dependencies on PER_PEOPLE_F

Line 67: per_people_f ppf

63: select ppf.full_name,
64: ppf.employee_number,
65: paf.assignment_number
66: from per_assignments_f paf,
67: per_people_f ppf
68: where ppf.person_id = paf.person_id and
69: sysdate between ppf.effective_start_date and
70: ppf.effective_end_date and
71: sysdate between paf.effective_start_date and

Line 103: from per_people_f

99: person_id, full_name,
100: to_char(effective_start_date,'MM/DD/YYYY') effective_start_date,
101: decode(to_char(effective_end_date,'MM/DD/YYYY'),'12/31/4712',NULL,
102: to_char(effective_end_date,'MM/DD/YYYY')) effective_end_date
103: from per_people_f
104: where person_id in (select person_id
105: from per_assignments_f
106: where assignment_id = p_assignment_id);
107:

Line 177: l_full_name per_people_f.full_name%TYPE;

173: l_header2 varchar2(240);
174: l_body varchar2(32000);
175:
176:
177: l_full_name per_people_f.full_name%TYPE;
178: l_employee_number per_people_f.employee_number%TYPE;
179: l_assignment_number per_assignments_f.assignment_number%TYPE;
180: begin
181:

Line 178: l_employee_number per_people_f.employee_number%TYPE;

174: l_body varchar2(32000);
175:
176:
177: l_full_name per_people_f.full_name%TYPE;
178: l_employee_number per_people_f.employee_number%TYPE;
179: l_assignment_number per_assignments_f.assignment_number%TYPE;
180: begin
181:
182: --hr_utility.trace_on(1,'pg');