APPS.EAM_ACTIVITYASSOCIATION_PVT dependencies on MFG_LOOKUPS

Line 745: from mfg_lookups

741:
742: -- Validate Priority Code
743: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Priority_Code IS NOT NULL THEN
744: select count(*) into l_count
745: from mfg_lookups
746: where lookup_type = g_act_priority
747: and sysdate between nvl(start_date_active,sysdate)
748: and nvl(end_date_active,sysdate)
749: and nvl(enabled_flag, 'N') = 'Y'

Line 801: from mfg_lookups

797:
798: -- Validate Activity Type Code
799: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Type_Code IS NOT NULL THEN
800: select count(*) into l_count
801: from mfg_lookups
802: where lookup_type = g_act_type
803: and sysdate between nvl(start_date_active,sysdate)
804: and nvl(end_date_active,sysdate)
805: and nvl(enabled_flag, 'N') = 'Y'

Line 829: from mfg_lookups

825:
826: -- Validate Activity Cause Code
827: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Cause_Code IS NOT NULL THEN
828: select count(*) into l_count
829: from mfg_lookups
830: where lookup_type = g_act_cause
831: and sysdate between nvl(start_date_active,sysdate)
832: and nvl(end_date_active,sysdate)
833: and nvl(enabled_flag, 'N') = 'Y'

Line 857: from mfg_lookups

853:
854: -- Validate Activity Source Code
855: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Source_Code IS NOT NULL THEN
856: select count(*) into l_count
857: from mfg_lookups
858: where lookup_type = g_act_source
859: and sysdate between nvl(start_date_active,sysdate)
860: and nvl(end_date_active,sysdate)
861: and nvl(enabled_flag, 'N') = 'Y'

Line 885: from mfg_lookups

881:
882: -- Validate Shutdown Type Code
883: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Shutdown_Type_Code IS NOT NULL THEN
884: select count(*) into l_count
885: from mfg_lookups
886: where lookup_type = g_shutdown_type
887: and sysdate between nvl(start_date_active,sysdate)
888: and nvl(end_date_active,sysdate)
889: and nvl(enabled_flag, 'N') = 'Y'