APPS.FTE_ACS_RULE_UTIL_PKG dependencies on FTE_SEL_GROUPS

Line 1092: FTE_SEL_GROUPS FSG

1088: fsset.fob_code
1089: -- We do not fetch start date and end date here as we are not going to cache this information.
1090: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,
1091: FTE_SEL_GROUP_ASSIGNMENTS FSGA,
1092: FTE_SEL_GROUPS FSG
1093: WHERE fsga.customer_site_id = fsset.customer_site_id
1094: AND fsga.group_id = fsg.group_id
1095: AND fsg.object_id = g_object_id
1096: --AND nvl(fsg.group_status_flag,'A') NOT IN ('D','I')

Line 1122: FTE_SEL_GROUPS FSG

1118: fsset.fob_code
1119: -- We do not fetch start date and end date here as we are not going to cache this information.
1120: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,
1121: FTE_SEL_GROUP_ASSIGNMENTS FSGA,
1122: FTE_SEL_GROUPS FSG
1123: WHERE fsga.customer_id = fsset.customer_id
1124: AND fsga.group_id = fsg.group_id
1125: AND fsg.object_id = g_object_id
1126: --AND nvl(fsg.group_status_flag,'A') NOT IN ('D','I')

Line 1152: FTE_SEL_GROUPS FSG

1148: fsset.fob_code
1149: -- We do not fetch start date and end date here as we are not going to cache this information.
1150: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,
1151: FTE_SEL_GROUP_ASSIGNMENTS FSGA,
1152: FTE_SEL_GROUPS FSG
1153: WHERE fsga.organization_id = fsset.organization_id
1154: AND fsga.group_id = fsg.group_id
1155: AND fsg.object_id = g_object_id
1156: --AND nvl(fsg.group_status_flag,'A') NOT IN ('D','I')

Line 1184: FTE_SEL_GROUPS FSG

1180: fsset.fob_code
1181: -- We do not fetch start date and end date here as we are not going to cache this information.
1182: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,
1183: FTE_SEL_GROUP_ASSIGNMENTS FSGA,
1184: FTE_SEL_GROUPS FSG
1185: WHERE fsga.organization_id = fsset.triporigin_internalorg_id
1186: AND fsga.group_id = fsg.group_id
1187: AND fsg.object_id = g_object_id
1188: --AND nvl(fsg.group_status_flag,'A') NOT IN ('D','I')

Line 1214: FTE_SEL_GROUPS FSG,

1210: fsset.ultimate_dropoff_loc_id,
1211: fsset.fob_code
1212: -- We do not fetch start date and end date here as we are not going to cache this information.
1213: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,
1214: FTE_SEL_GROUPS FSG,
1215: FTE_SEL_GROUP_ASSIGNMENTS assign
1216: WHERE --assigned_flag = 'E'
1217: --AND
1218: fsg.object_id = g_object_id

Line 1241: fte_sel_groups fsg

1237: SELECT fsg.group_id,
1238: fsg.start_date,
1239: fsg.end_date
1240: FROM fte_sel_group_assignments fsga,
1241: fte_sel_groups fsg
1242: WHERE fsga.customer_site_id = p_customer_site_id
1243: AND fsga.group_id = fsg.group_id
1244: AND fsg.object_id = g_object_id
1245: --AND nvl(fsg.group_status_flag,'A') NOT IN ('D','I')

Line 1261: fte_sel_groups fsg

1257: SELECT fsg.group_id,
1258: fsg.start_date,
1259: fsg.end_date
1260: FROM fte_sel_group_assignments fsga,
1261: fte_sel_groups fsg
1262: WHERE fsga.customer_id = p_customer_id
1263: AND fsga.group_id = fsg.group_id
1264: AND fsg.object_id = g_object_id
1265: --AND nvl(fsg.group_status_flag,'A') NOT IN ('D','I')

Line 1281: fte_sel_groups fsg

1277: SELECT fsg.group_id,
1278: fsg.start_date,
1279: fsg.end_date
1280: FROM fte_sel_group_assignments fsga,
1281: fte_sel_groups fsg
1282: WHERE fsga.organization_id = p_org_id
1283: AND fsga.group_id = fsg.group_id
1284: AND fsg.object_id = g_object_id
1285: --AND nvl(fsg.group_status_flag,'A') NOT IN ('D','I')

Line 1299: FROM fte_sel_groups fsg,

1295: CURSOR c_get_ship_group(p_ship_date DATE) IS
1296: SELECT fsg.group_id,
1297: fsg.start_date,
1298: fsg.end_date
1299: FROM fte_sel_groups fsg,
1300: FTE_SEL_GROUP_ASSIGNMENTS assign
1301: WHERE --assigned_flag = 'E'
1302: --AND
1303: fsg.object_id = g_object_id