APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PER_ALL_PEOPLE_F

Line 325: per_all_people_f pp

321: p_sqlstr :=
322: 'select /*+ ORDERED */
323: distinct pp.person_id
324: from pay_payroll_actions ppa,
325: per_all_people_f pp
326: where ppa.payroll_action_id = :payroll_action_id
327: and pp.business_group_id = ppa.business_group_id + 0
328: order by pp.person_id';
329: --

Line 1177: per_all_people_f pp,

1173: trim(substrb(decode(par.address_id,null,
1174: pac.address_line1||pac.address_line2||pac.address_line3,
1175: par.address_line1||par.address_line2||par.address_line3),1,240)) address
1176: from per_all_assignments_f pa,
1177: per_all_people_f pp,
1178: per_addresses par,
1179: per_addresses pac
1180: where pa.assignment_id = p_assignment_id
1181: and g_effective_date