APPS.PAY_NL_PAYFILE dependencies on PER_ALL_ASSIGNMENTS_F

Line 240: FROM per_all_assignments_f paf

236: --
237: l_payee_name := substr(l_outputs(1).value,1,32);
238:
239: SELECT person_id INTO l_payee_id
240: FROM per_all_assignments_f paf
241: WHERE paf.assignment_id = p_assignment_id
242: AND p_date_earned BETWEEN paf.effective_start_date
243: AND paf.effective_end_date;
244:

Line 258: FROM per_all_assignments_f paf

254: END IF;
255: END IF;
256:
257: SELECT person_id INTO l_payee_id
258: FROM per_all_assignments_f paf
259: WHERE paf.assignment_id = p_assignment_id
260: AND p_date_earned BETWEEN paf.effective_start_date
261: AND paf.effective_end_date;
262: