APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 361: per_all_assignments_f pa

357: is
358: select /*+ ORDERED */
359: pa.assignment_id
360: from per_periods_of_service ppos,
361: per_all_assignments_f pa
362: where ppos.person_id
363: between p_start_person_id and p_end_person_id
364: and ppos.business_group_id + 0 = g_business_group_id
365: and g_effective_date

Line 1176: from per_all_assignments_f pa,

1172: decode(par.address_id,null,pac.postal_code,par.postal_code) postal_code,
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