APPS.PQP_EXPREPLOD_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 225: FROM per_all_assignments_f

221: WHERE organization_id=(SELECT segment1
222: FROM hr_soft_coding_keyflex
223: WHERE soft_coding_keyflex_id =
224: (SELECT soft_coding_keyflex_id
225: FROM per_all_assignments_f
226: WHERE assignment_id=p_assignment_id
227: AND p_paydate BETWEEN effective_start_date
228: AND effective_end_date));
229:

Line 313: FROM hr_soft_coding_keyflex hsck, per_all_assignments_f paaf

309:
310: ELSIF (l_instr_count3 > 0 AND l_supported_loc = 'N') THEN
311: hr_utility.trace('Entered IP Tax Unit case');
312: SELECT hsck.segment1 INTO l_tax_unit
313: FROM hr_soft_coding_keyflex hsck, per_all_assignments_f paaf
314: WHERE paaf.assignment_id = p_assignment_id
315: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
316: AND sysdate BETWEEN paaf.effective_start_date AND paaf.effective_end_date;
317:

Line 375: per_all_assignments_f paaf

371:
372: CURSOR c_tax_unit_id IS
373: SELECT segment1,segment11,segment12
374: FROM hr_soft_coding_keyflex hsck,
375: per_all_assignments_f paaf
376: WHERE paaf.assignment_id = p_assignment_id
377: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
378: AND p_paydate BETWEEN paaf.effective_start_date AND paaf.effective_end_date;
379: