APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PER_ALL_PEOPLE_F

Line 322: per_all_people_f pp

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

Line 1143: per_all_people_f pp,

1139: trim(substrb(decode(par.address_id,null,
1140: pac.address_line1||pac.address_line2||pac.address_line3,
1141: par.address_line1||par.address_line2||par.address_line3),1,240)) address
1142: from per_all_assignments_f pa,
1143: per_all_people_f pp,
1144: per_addresses par,
1145: per_addresses pac
1146: where pa.assignment_id = p_assignment_id
1147: and g_effective_date