APPS.PAY_ASG_DEBUG_PKG dependencies on PER_ASSIGNMENTS_F

Line 66: from per_assignments_f paf,

62: cursor cur_header2 is
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

Line 87: from per_assignments_f paf,

83: ppf.payroll_name payroll_name,
84: paf.pay_basis_id pay_basis_id,
85: ppb.name name,
86: ltrim(rtrim(paf.soft_coding_keyflex_id)) sfckid
87: from per_assignments_f paf,
88: per_pay_bases ppb,
89: pay_payrolls_f ppf,
90: hr_locations hl
91: where assignment_id = p_assignment_id

Line 105: from per_assignments_f

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:
108: cursor cur_address is select
109: ltrim(rtrim(primary_flag)) primary_flag,

Line 115: from per_assignments_f

111: ltrim(rtrim(region_2)) region_2,
112: ltrim(rtrim(town_or_city)) town_or_city
113: from per_addresses
114: where person_id in (select person_id
115: from per_assignments_f
116: where assignment_id = p_assignment_id);
117:
118: cursor cur_federal is select
119: sui_jurisdiction_code,

Line 179: l_assignment_number per_assignments_f.assignment_number%TYPE;

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');
183: