APPS.EAM_ACTIVITYASSOCIATION_PVT dependencies on MFG_LOOKUPS

Line 770: from mfg_lookups

766:
767: -- Validate Priority Code
768: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Priority_Code IS NOT NULL THEN
769: select count(*) into l_count
770: from mfg_lookups
771: where lookup_type = g_act_priority
772: and sysdate between nvl(start_date_active,sysdate)
773: and nvl(end_date_active,sysdate)
774: and nvl(enabled_flag, 'N') = 'Y'

Line 826: from mfg_lookups

822:
823: -- Validate Activity Type Code
824: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Type_Code IS NOT NULL THEN
825: select count(*) into l_count
826: from mfg_lookups
827: where lookup_type = g_act_type
828: and sysdate between nvl(start_date_active,sysdate)
829: and nvl(end_date_active,sysdate)
830: and nvl(enabled_flag, 'N') = 'Y'

Line 854: from mfg_lookups

850:
851: -- Validate Activity Cause Code
852: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Cause_Code IS NOT NULL THEN
853: select count(*) into l_count
854: from mfg_lookups
855: where lookup_type = g_act_cause
856: and sysdate between nvl(start_date_active,sysdate)
857: and nvl(end_date_active,sysdate)
858: and nvl(enabled_flag, 'N') = 'Y'

Line 882: from mfg_lookups

878:
879: -- Validate Activity Source Code
880: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Source_Code IS NOT NULL THEN
881: select count(*) into l_count
882: from mfg_lookups
883: where lookup_type = g_act_source
884: and sysdate between nvl(start_date_active,sysdate)
885: and nvl(end_date_active,sysdate)
886: and nvl(enabled_flag, 'N') = 'Y'

Line 911: from mfg_lookups

907: -- Added for 16525236
908: -- Validate Work Order Type
909: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Work_Order_Type IS NOT NULL THEN
910: select count(*) into l_count
911: from mfg_lookups
912: where lookup_type = G_WORK_ORDER_TYPE
913: and sysdate between nvl(start_date_active,sysdate)
914: and nvl(end_date_active,sysdate)
915: and nvl(enabled_flag, 'N') = 'Y'

Line 938: from mfg_lookups

934:
935: -- Validate Planner
936: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Planner IS NOT NULL THEN
937: select count(*) into l_count
938: from mfg_lookups
939: where lookup_type = G_PLANNER
940: and sysdate between nvl(start_date_active,sysdate)
941: and nvl(end_date_active,sysdate)
942: and nvl(enabled_flag, 'N') = 'Y'

Line 966: from mfg_lookups

962:
963: -- Validate Shutdown Type Code
964: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Shutdown_Type_Code IS NOT NULL THEN
965: select count(*) into l_count
966: from mfg_lookups
967: where lookup_type = g_shutdown_type
968: and sysdate between nvl(start_date_active,sysdate)
969: and nvl(end_date_active,sysdate)
970: and nvl(enabled_flag, 'N') = 'Y'