eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 358: per_all_assignments_f pa

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

Line 1142: from per_all_assignments_f pa,

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