APPS.PAY_AU_TFN_MAGTAPE_FLAGS dependencies on PER_ASSIGNMENTS_F

Line 139: FROM per_assignments_f a

135: OR nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY')) BETWEEN c_report_end_date - 13 AND c_report_end_date
136: )
137: ) /* Bug#5864230 */
138: AND paa.effective_start_date = (SELECT max(effective_start_date)
139: FROM per_assignments_f a
140: WHERE a.assignment_id = paa.assignment_id)
141: and pap.effective_start_date=(select max(effective_start_date)
142: from per_people_f p
143: where p.person_id=pap.person_id) --Bug 4925794

Line 242: c_assignment_id per_assignments_f.assignment_id%TYPE ) IS

238:
239: CURSOR c_get_tfn_super_flag_value(c_business_group_id in per_business_groups.business_group_id%TYPE,
240: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,
241: c_report_end_date in date,
242: c_assignment_id per_assignments_f.assignment_id%TYPE ) IS
243: SELECT pee.assignment_id
244: ,pev.screen_entry_value tfn_for_super_flag
245: FROM per_assignments_f paa,
246: hr_soft_coding_keyflex hsc,

Line 245: FROM per_assignments_f paa,

241: c_report_end_date in date,
242: c_assignment_id per_assignments_f.assignment_id%TYPE ) IS
243: SELECT pee.assignment_id
244: ,pev.screen_entry_value tfn_for_super_flag
245: FROM per_assignments_f paa,
246: hr_soft_coding_keyflex hsc,
247: pay_element_entry_values_f pev,
248: pay_input_values_f piv,
249: pay_element_types_f pet,

Line 271: FROM per_assignments_f a

267: WHERE pee1.element_entry_id = pee.element_entry_id
268: AND pee1.effective_start_date <= c_report_end_date
269: )
270: AND paa.effective_start_date = (SELECT max(effective_start_date)
271: FROM per_assignments_f a
272: WHERE a.assignment_id = paa.assignment_id
273: )
274: AND pev.effective_start_date = (SELECT max(pev1.effective_start_date)
275: FROM pay_element_entry_values_f pev1