2500:
2501: UPDATE hz_customer_profiles yt --5634398
2502: SET status = 'A',
2503: last_update_date = sysdate,
2504: last_updated_by = arp_standard.profile.user_id,
2505: last_update_login = arp_standard.profile.last_update_login,
2506: request_id = req_id,
2507: program_application_id = arp_standard.profile.program_application_id,
2508: program_id = arp_standard.profile.program_id,
2501: UPDATE hz_customer_profiles yt --5634398
2502: SET status = 'A',
2503: last_update_date = sysdate,
2504: last_updated_by = arp_standard.profile.user_id,
2505: last_update_login = arp_standard.profile.last_update_login,
2506: request_id = req_id,
2507: program_application_id = arp_standard.profile.program_application_id,
2508: program_id = arp_standard.profile.program_id,
2509: program_update_date = sysdate
2503: last_update_date = sysdate,
2504: last_updated_by = arp_standard.profile.user_id,
2505: last_update_login = arp_standard.profile.last_update_login,
2506: request_id = req_id,
2507: program_application_id = arp_standard.profile.program_application_id,
2508: program_id = arp_standard.profile.program_id,
2509: program_update_date = sysdate
2510: WHERE part_delete = 'Y'
2511: AND status = 'D'
2504: last_updated_by = arp_standard.profile.user_id,
2505: last_update_login = arp_standard.profile.last_update_login,
2506: request_id = req_id,
2507: program_application_id = arp_standard.profile.program_application_id,
2508: program_id = arp_standard.profile.program_id,
2509: program_update_date = sysdate
2510: WHERE part_delete = 'Y'
2511: AND status = 'D'
2512: AND yt.cust_account_id = from_customer_id