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.AMS_CAMPAIGN_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 67: SELECT 1 FROM hr_all_organization_units_vl

63: SELECT business_unit_id
64: from ams_campaigns_all_b
65: where campaign_id = p_parent_campaign_id
66: and exists (
67: SELECT 1 FROM hr_all_organization_units_vl
68: WHERE business_group_id IN (
69: SELECT business_group_id FROM hr_all_organization_units_vl
70: WHERE organization_id = p_org_id
71: AND NVL(date_from, SYSDATE) <= SYSDATE

Line 69: SELECT business_group_id FROM hr_all_organization_units_vl

65: where campaign_id = p_parent_campaign_id
66: and exists (
67: SELECT 1 FROM hr_all_organization_units_vl
68: WHERE business_group_id IN (
69: SELECT business_group_id FROM hr_all_organization_units_vl
70: WHERE organization_id = p_org_id
71: AND NVL(date_from, SYSDATE) <= SYSDATE
72: AND NVL(date_to, SYSDATE) >= SYSDATE)
73: AND type = 'BU'

Line 86: FROM hr_all_organization_units_vl

82: from ams_campaigns_all_b
83: where campaign_id = p_parent_campaign_id
84: and exists (
85: SELECT 1
86: FROM hr_all_organization_units_vl
87: WHERE business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
88: AND NVL(date_from, SYSDATE) <= SYSDATE
89: AND NVL(date_to, SYSDATE) >= SYSDATE
90: AND type = 'BU'