692: l_max_date date := null;
693: --
694: cursor csr_max_updated_date is
695: select GREATEST (
696: NVL (MAX (addr.last_update_date), hr_api.g_sot),
697: NVL (MAX (phn.last_update_date), hr_api.g_sot),
698: NVL (MAX (ido.last_update_date), hr_api.g_sot),
699: NVL (MAX (pem.last_update_date), hr_api.g_sot),
700: NVL (MAX (esa.last_update_date), hr_api.g_sot),
693: --
694: cursor csr_max_updated_date is
695: select GREATEST (
696: NVL (MAX (addr.last_update_date), hr_api.g_sot),
697: NVL (MAX (phn.last_update_date), hr_api.g_sot),
698: NVL (MAX (ido.last_update_date), hr_api.g_sot),
699: NVL (MAX (pem.last_update_date), hr_api.g_sot),
700: NVL (MAX (esa.last_update_date), hr_api.g_sot),
701: NVL (MAX (qua.last_update_date), hr_api.g_sot),
694: cursor csr_max_updated_date is
695: select GREATEST (
696: NVL (MAX (addr.last_update_date), hr_api.g_sot),
697: NVL (MAX (phn.last_update_date), hr_api.g_sot),
698: NVL (MAX (ido.last_update_date), hr_api.g_sot),
699: NVL (MAX (pem.last_update_date), hr_api.g_sot),
700: NVL (MAX (esa.last_update_date), hr_api.g_sot),
701: NVL (MAX (qua.last_update_date), hr_api.g_sot),
702: NVL (MAX (pce.last_update_date), hr_api.g_sot),
695: select GREATEST (
696: NVL (MAX (addr.last_update_date), hr_api.g_sot),
697: NVL (MAX (phn.last_update_date), hr_api.g_sot),
698: NVL (MAX (ido.last_update_date), hr_api.g_sot),
699: NVL (MAX (pem.last_update_date), hr_api.g_sot),
700: NVL (MAX (esa.last_update_date), hr_api.g_sot),
701: NVL (MAX (qua.last_update_date), hr_api.g_sot),
702: NVL (MAX (pce.last_update_date), hr_api.g_sot),
703: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
696: NVL (MAX (addr.last_update_date), hr_api.g_sot),
697: NVL (MAX (phn.last_update_date), hr_api.g_sot),
698: NVL (MAX (ido.last_update_date), hr_api.g_sot),
699: NVL (MAX (pem.last_update_date), hr_api.g_sot),
700: NVL (MAX (esa.last_update_date), hr_api.g_sot),
701: NVL (MAX (qua.last_update_date), hr_api.g_sot),
702: NVL (MAX (pce.last_update_date), hr_api.g_sot),
703: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
704: NVL (MAX (iscw.last_update_date), hr_api.g_sot),
697: NVL (MAX (phn.last_update_date), hr_api.g_sot),
698: NVL (MAX (ido.last_update_date), hr_api.g_sot),
699: NVL (MAX (pem.last_update_date), hr_api.g_sot),
700: NVL (MAX (esa.last_update_date), hr_api.g_sot),
701: NVL (MAX (qua.last_update_date), hr_api.g_sot),
702: NVL (MAX (pce.last_update_date), hr_api.g_sot),
703: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
704: NVL (MAX (iscw.last_update_date), hr_api.g_sot),
705: NVL (MAX (iscp.last_update_date), hr_api.g_sot),
698: NVL (MAX (ido.last_update_date), hr_api.g_sot),
699: NVL (MAX (pem.last_update_date), hr_api.g_sot),
700: NVL (MAX (esa.last_update_date), hr_api.g_sot),
701: NVL (MAX (qua.last_update_date), hr_api.g_sot),
702: NVL (MAX (pce.last_update_date), hr_api.g_sot),
703: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
704: NVL (MAX (iscw.last_update_date), hr_api.g_sot),
705: NVL (MAX (iscp.last_update_date), hr_api.g_sot),
706: MAX (per2.last_update_date),
699: NVL (MAX (pem.last_update_date), hr_api.g_sot),
700: NVL (MAX (esa.last_update_date), hr_api.g_sot),
701: NVL (MAX (qua.last_update_date), hr_api.g_sot),
702: NVL (MAX (pce.last_update_date), hr_api.g_sot),
703: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
704: NVL (MAX (iscw.last_update_date), hr_api.g_sot),
705: NVL (MAX (iscp.last_update_date), hr_api.g_sot),
706: MAX (per2.last_update_date),
707: NVL (MAX (asg.last_update_date), hr_api.g_sot)
700: NVL (MAX (esa.last_update_date), hr_api.g_sot),
701: NVL (MAX (qua.last_update_date), hr_api.g_sot),
702: NVL (MAX (pce.last_update_date), hr_api.g_sot),
703: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
704: NVL (MAX (iscw.last_update_date), hr_api.g_sot),
705: NVL (MAX (iscp.last_update_date), hr_api.g_sot),
706: MAX (per2.last_update_date),
707: NVL (MAX (asg.last_update_date), hr_api.g_sot)
708: )
701: NVL (MAX (qua.last_update_date), hr_api.g_sot),
702: NVL (MAX (pce.last_update_date), hr_api.g_sot),
703: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
704: NVL (MAX (iscw.last_update_date), hr_api.g_sot),
705: NVL (MAX (iscp.last_update_date), hr_api.g_sot),
706: MAX (per2.last_update_date),
707: NVL (MAX (asg.last_update_date), hr_api.g_sot)
708: )
709: from per_addresses addr,
703: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
704: NVL (MAX (iscw.last_update_date), hr_api.g_sot),
705: NVL (MAX (iscp.last_update_date), hr_api.g_sot),
706: MAX (per2.last_update_date),
707: NVL (MAX (asg.last_update_date), hr_api.g_sot)
708: )
709: from per_addresses addr,
710: per_phones phn,
711: irc_documents ido,