DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PER_ADDRESSES

Line 1144: per_addresses par,

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
1148: between pa.effective_start_date and pa.effective_end_date

Line 1145: per_addresses pac

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
1148: between pa.effective_start_date and pa.effective_end_date
1149: and pp.person_id = pa.person_id