DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PER_ADDRESSES

Line 1178: per_addresses par,

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

Line 1179: per_addresses pac

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