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.IRC_PURGE_OLD_DATA_PKG dependencies on HR_API

Line 569: NVL (MAX (addr.last_update_date), hr_api.g_sot),

565: l_max_date date := null;
566: --
567: cursor csr_max_updated_date is
568: select GREATEST (
569: NVL (MAX (addr.last_update_date), hr_api.g_sot),
570: NVL (MAX (phn.last_update_date), hr_api.g_sot),
571: NVL (MAX (ido.last_update_date), hr_api.g_sot),
572: NVL (MAX (pem.last_update_date), hr_api.g_sot),
573: NVL (MAX (esa.last_update_date), hr_api.g_sot),

Line 570: NVL (MAX (phn.last_update_date), hr_api.g_sot),

566: --
567: cursor csr_max_updated_date is
568: select GREATEST (
569: NVL (MAX (addr.last_update_date), hr_api.g_sot),
570: NVL (MAX (phn.last_update_date), hr_api.g_sot),
571: NVL (MAX (ido.last_update_date), hr_api.g_sot),
572: NVL (MAX (pem.last_update_date), hr_api.g_sot),
573: NVL (MAX (esa.last_update_date), hr_api.g_sot),
574: NVL (MAX (qua.last_update_date), hr_api.g_sot),

Line 571: NVL (MAX (ido.last_update_date), hr_api.g_sot),

567: cursor csr_max_updated_date is
568: select GREATEST (
569: NVL (MAX (addr.last_update_date), hr_api.g_sot),
570: NVL (MAX (phn.last_update_date), hr_api.g_sot),
571: NVL (MAX (ido.last_update_date), hr_api.g_sot),
572: NVL (MAX (pem.last_update_date), hr_api.g_sot),
573: NVL (MAX (esa.last_update_date), hr_api.g_sot),
574: NVL (MAX (qua.last_update_date), hr_api.g_sot),
575: NVL (MAX (pce.last_update_date), hr_api.g_sot),

Line 572: NVL (MAX (pem.last_update_date), hr_api.g_sot),

568: select GREATEST (
569: NVL (MAX (addr.last_update_date), hr_api.g_sot),
570: NVL (MAX (phn.last_update_date), hr_api.g_sot),
571: NVL (MAX (ido.last_update_date), hr_api.g_sot),
572: NVL (MAX (pem.last_update_date), hr_api.g_sot),
573: NVL (MAX (esa.last_update_date), hr_api.g_sot),
574: NVL (MAX (qua.last_update_date), hr_api.g_sot),
575: NVL (MAX (pce.last_update_date), hr_api.g_sot),
576: NVL (MAX (jbo.last_update_date), hr_api.g_sot),

Line 573: NVL (MAX (esa.last_update_date), hr_api.g_sot),

569: NVL (MAX (addr.last_update_date), hr_api.g_sot),
570: NVL (MAX (phn.last_update_date), hr_api.g_sot),
571: NVL (MAX (ido.last_update_date), hr_api.g_sot),
572: NVL (MAX (pem.last_update_date), hr_api.g_sot),
573: NVL (MAX (esa.last_update_date), hr_api.g_sot),
574: NVL (MAX (qua.last_update_date), hr_api.g_sot),
575: NVL (MAX (pce.last_update_date), hr_api.g_sot),
576: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
577: NVL (MAX (iscw.last_update_date), hr_api.g_sot),

Line 574: NVL (MAX (qua.last_update_date), hr_api.g_sot),

570: NVL (MAX (phn.last_update_date), hr_api.g_sot),
571: NVL (MAX (ido.last_update_date), hr_api.g_sot),
572: NVL (MAX (pem.last_update_date), hr_api.g_sot),
573: NVL (MAX (esa.last_update_date), hr_api.g_sot),
574: NVL (MAX (qua.last_update_date), hr_api.g_sot),
575: NVL (MAX (pce.last_update_date), hr_api.g_sot),
576: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
577: NVL (MAX (iscw.last_update_date), hr_api.g_sot),
578: NVL (MAX (iscp.last_update_date), hr_api.g_sot),

Line 575: NVL (MAX (pce.last_update_date), hr_api.g_sot),

571: NVL (MAX (ido.last_update_date), hr_api.g_sot),
572: NVL (MAX (pem.last_update_date), hr_api.g_sot),
573: NVL (MAX (esa.last_update_date), hr_api.g_sot),
574: NVL (MAX (qua.last_update_date), hr_api.g_sot),
575: NVL (MAX (pce.last_update_date), hr_api.g_sot),
576: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
577: NVL (MAX (iscw.last_update_date), hr_api.g_sot),
578: NVL (MAX (iscp.last_update_date), hr_api.g_sot),
579: MAX (per2.last_update_date),

Line 576: NVL (MAX (jbo.last_update_date), hr_api.g_sot),

572: NVL (MAX (pem.last_update_date), hr_api.g_sot),
573: NVL (MAX (esa.last_update_date), hr_api.g_sot),
574: NVL (MAX (qua.last_update_date), hr_api.g_sot),
575: NVL (MAX (pce.last_update_date), hr_api.g_sot),
576: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
577: NVL (MAX (iscw.last_update_date), hr_api.g_sot),
578: NVL (MAX (iscp.last_update_date), hr_api.g_sot),
579: MAX (per2.last_update_date),
580: NVL (MAX (asg.last_update_date), hr_api.g_sot)

Line 577: NVL (MAX (iscw.last_update_date), hr_api.g_sot),

573: NVL (MAX (esa.last_update_date), hr_api.g_sot),
574: NVL (MAX (qua.last_update_date), hr_api.g_sot),
575: NVL (MAX (pce.last_update_date), hr_api.g_sot),
576: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
577: NVL (MAX (iscw.last_update_date), hr_api.g_sot),
578: NVL (MAX (iscp.last_update_date), hr_api.g_sot),
579: MAX (per2.last_update_date),
580: NVL (MAX (asg.last_update_date), hr_api.g_sot)
581: )

Line 578: NVL (MAX (iscp.last_update_date), hr_api.g_sot),

574: NVL (MAX (qua.last_update_date), hr_api.g_sot),
575: NVL (MAX (pce.last_update_date), hr_api.g_sot),
576: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
577: NVL (MAX (iscw.last_update_date), hr_api.g_sot),
578: NVL (MAX (iscp.last_update_date), hr_api.g_sot),
579: MAX (per2.last_update_date),
580: NVL (MAX (asg.last_update_date), hr_api.g_sot)
581: )
582: from per_addresses addr,

Line 580: NVL (MAX (asg.last_update_date), hr_api.g_sot)

576: NVL (MAX (jbo.last_update_date), hr_api.g_sot),
577: NVL (MAX (iscw.last_update_date), hr_api.g_sot),
578: NVL (MAX (iscp.last_update_date), hr_api.g_sot),
579: MAX (per2.last_update_date),
580: NVL (MAX (asg.last_update_date), hr_api.g_sot)
581: )
582: from per_addresses addr,
583: per_phones phn,
584: irc_documents ido,