APPS.PAY_CA_RL2_REG dependencies on PER_ASSIGNMENTS_F

Line 194: from per_assignments_f paf

190:
191: cursor c_get_asg_id (p_person_id number) is
192: select paf.assignment_id,
193: paf.effective_end_date
194: from per_assignments_f paf
195: where person_id = p_person_id
196: and primary_flag = 'Y'
197: and assignment_type = 'E'
198: and paf.effective_start_date <= l_year_end

Line 206: from per_assignments_f paf,

202: --Changes for bug 15886428 starts
203: cursor c_get_asg_id_term (p_person_id number) is
204: select paf.assignment_id,
205: paf.effective_end_date
206: from per_assignments_f paf,
207: per_periods_of_service pds
208: where paf.person_id = p_person_id
209: and paf.primary_flag = 'Y'
210: and paf.assignment_type = 'E'

Line 312: per_assignments_f paf

308: and ppa.payroll_action_id = paa.payroll_action_id
309: and to_number(paa.serial_number) between stperson and endperson
310: and exists (select 1
311: from hr_assignment_set_amendments hasa,
312: per_assignments_f paf
313: where hasa.assignment_set_id = l_asg_set_id
314: and upper(hasa.include_or_exclude) = 'I'
315: and hasa.assignment_id = paf.assignment_id
316: and paf.person_id = to_number(paa.serial_number));

Line 345: per_assignments_f paf

341: and ppr.chunk_number = chunk
342: and ppr.person_id = to_number(paa.serial_number)
343: and exists (select 1
344: from hr_assignment_set_amendments hasa,
345: per_assignments_f paf
346: where hasa.assignment_set_id = l_asg_set_id
347: and upper(hasa.include_or_exclude) = 'I'
348: and hasa.assignment_id = paf.assignment_id
349: and paf.person_id = to_number(paa.serial_number))